latimes_agency_totals
Data license: Reusing the data · Data source: The Los Angeles Times · About: Data dictionary for latimes_agency_totals
559 rows where fips = 73 sorted by confirmed_cases
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | agency | county | fips | date | confirmed_cases ▼ | deaths | did_not_update |
---|---|---|---|---|---|---|---|---|
27978 | 27978 | San Diego | San Diego | 73 | 2020-06-01 | 7554 | 269 | |
27917 | 27917 | San Diego | San Diego | 73 | 2020-06-02 | 7674 | 276 | |
27856 | 27856 | San Diego | San Diego | 73 | 2020-06-03 | 7798 | 283 | |
27795 | 27795 | San Diego | San Diego | 73 | 2020-06-04 | 7940 | 288 | |
27734 | 27734 | San Diego | San Diego | 73 | 2020-06-05 | 8180 | 294 | |
27673 | 27673 | San Diego | San Diego | 73 | 2020-06-06 | 8345 | 296 | |
27612 | 27612 | San Diego | San Diego | 73 | 2020-06-07 | 8476 | 296 | |
27551 | 27551 | San Diego | San Diego | 73 | 2020-06-08 | 8619 | 296 | |
27490 | 27490 | San Diego | San Diego | 73 | 2020-06-09 | 8729 | 301 | |
27429 | 27429 | San Diego | San Diego | 73 | 2020-06-10 | 8837 | 305 | |
27368 | 27368 | San Diego | San Diego | 73 | 2020-06-11 | 8998 | 308 | |
27307 | 27307 | San Diego | San Diego | 73 | 2020-06-12 | 9130 | 313 | |
27246 | 27246 | San Diego | San Diego | 73 | 2020-06-13 | 9314 | 319 | |
27185 | 27185 | San Diego | San Diego | 73 | 2020-06-14 | 9440 | 319 | |
27124 | 27124 | San Diego | San Diego | 73 | 2020-06-15 | 9610 | 320 | |
27063 | 27063 | San Diego | San Diego | 73 | 2020-06-16 | 9730 | 323 | |
27002 | 27002 | San Diego | San Diego | 73 | 2020-06-17 | 9854 | 327 | |
26941 | 26941 | San Diego | San Diego | 73 | 2020-06-18 | 10092 | 331 | |
26880 | 26880 | San Diego | San Diego | 73 | 2020-06-19 | 10350 | 332 | |
26819 | 26819 | San Diego | San Diego | 73 | 2020-06-20 | 10484 | 338 | |
26758 | 26758 | San Diego | San Diego | 73 | 2020-06-21 | 10794 | 338 | |
26697 | 26697 | San Diego | San Diego | 73 | 2020-06-22 | 11096 | 338 | |
26636 | 26636 | San Diego | San Diego | 73 | 2020-06-23 | 11294 | 341 | |
26575 | 26575 | San Diego | San Diego | 73 | 2020-06-24 | 11626 | 347 | |
26514 | 26514 | San Diego | San Diego | 73 | 2020-06-25 | 11961 | 352 | |
26453 | 26453 | San Diego | San Diego | 73 | 2020-06-26 | 12401 | 358 | |
26392 | 26392 | San Diego | San Diego | 73 | 2020-06-27 | 12837 | 360 | |
26331 | 26331 | San Diego | San Diego | 73 | 2020-06-28 | 13334 | 361 | |
26270 | 26270 | San Diego | San Diego | 73 | 2020-06-29 | 13832 | 361 | |
26209 | 26209 | San Diego | San Diego | 73 | 2020-06-30 | 14149 | 365 | |
26148 | 26148 | San Diego | San Diego | 73 | 2020-07-01 | 14623 | 372 | |
26087 | 26087 | San Diego | San Diego | 73 | 2020-07-02 | 15207 | 377 | |
25965 | 25965 | San Diego | San Diego | 73 | 2020-07-04 | 15696 | 387 | TRUE |
26026 | 26026 | San Diego | San Diego | 73 | 2020-07-03 | 15696 | 387 | |
25904 | 25904 | San Diego | San Diego | 73 | 2020-07-05 | 16726 | 387 | |
25843 | 25843 | San Diego | San Diego | 73 | 2020-07-06 | 17000 | 387 | |
25782 | 25782 | San Diego | San Diego | 73 | 2020-07-07 | 17578 | 399 | |
25721 | 25721 | San Diego | San Diego | 73 | 2020-07-08 | 17842 | 406 | |
25660 | 25660 | San Diego | San Diego | 73 | 2020-07-09 | 18402 | 415 | |
25599 | 25599 | San Diego | San Diego | 73 | 2020-07-10 | 18863 | 420 | |
25538 | 25538 | San Diego | San Diego | 73 | 2020-07-11 | 19371 | 422 | |
25477 | 25477 | San Diego | San Diego | 73 | 2020-07-12 | 19929 | 422 | |
25416 | 25416 | San Diego | San Diego | 73 | 2020-07-13 | 20348 | 422 | |
25355 | 25355 | San Diego | San Diego | 73 | 2020-07-14 | 20887 | 436 | |
25294 | 25294 | San Diego | San Diego | 73 | 2020-07-15 | 21446 | 448 | |
25233 | 25233 | San Diego | San Diego | 73 | 2020-07-16 | 21855 | 465 | |
25172 | 25172 | San Diego | San Diego | 73 | 2020-07-17 | 22489 | 472 | |
25111 | 25111 | San Diego | San Diego | 73 | 2020-07-18 | 23114 | 478 | |
25050 | 25050 | San Diego | San Diego | 73 | 2020-07-19 | 23682 | 478 | |
24989 | 24989 | San Diego | San Diego | 73 | 2020-07-20 | 24135 | 478 | |
24928 | 24928 | San Diego | San Diego | 73 | 2020-07-21 | 24520 | 487 | |
24867 | 24867 | San Diego | San Diego | 73 | 2020-07-22 | 25107 | 505 | |
24806 | 24806 | San Diego | San Diego | 73 | 2020-07-23 | 25608 | 512 | |
24745 | 24745 | San Diego | San Diego | 73 | 2020-07-24 | 26098 | 524 | |
24684 | 24684 | San Diego | San Diego | 73 | 2020-07-25 | 26701 | 533 | |
24623 | 24623 | San Diego | San Diego | 73 | 2020-07-26 | 26984 | 533 | |
24562 | 24562 | San Diego | San Diego | 73 | 2020-07-27 | 27507 | 533 | |
24501 | 24501 | San Diego | San Diego | 73 | 2020-07-28 | 28005 | 547 | |
24440 | 24440 | San Diego | San Diego | 73 | 2020-07-29 | 28287 | 552 | |
24379 | 24379 | San Diego | San Diego | 73 | 2020-07-30 | 28688 | 558 | |
24318 | 24318 | San Diego | San Diego | 73 | 2020-07-31 | 29048 | 561 | |
24257 | 24257 | San Diego | San Diego | 73 | 2020-08-01 | 29577 | 565 | |
24196 | 24196 | San Diego | San Diego | 73 | 2020-08-02 | 29883 | 565 | |
24135 | 24135 | San Diego | San Diego | 73 | 2020-08-03 | 30226 | 565 | |
24074 | 24074 | San Diego | San Diego | 73 | 2020-08-04 | 30516 | 568 | |
24013 | 24013 | San Diego | San Diego | 73 | 2020-08-05 | 30864 | 578 | |
23952 | 23952 | San Diego | San Diego | 73 | 2020-08-06 | 31127 | 583 | |
23891 | 23891 | San Diego | San Diego | 73 | 2020-08-07 | 31779 | 586 | |
23830 | 23830 | San Diego | San Diego | 73 | 2020-08-08 | 32330 | 593 | |
23769 | 23769 | San Diego | San Diego | 73 | 2020-08-09 | 32747 | 594 | |
23708 | 23708 | San Diego | San Diego | 73 | 2020-08-10 | 32975 | 594 | |
23647 | 23647 | San Diego | San Diego | 73 | 2020-08-11 | 33157 | 602 | |
23586 | 23586 | San Diego | San Diego | 73 | 2020-08-12 | 33393 | 608 | |
23525 | 23525 | San Diego | San Diego | 73 | 2020-08-13 | 33659 | 615 | |
23464 | 23464 | San Diego | San Diego | 73 | 2020-08-14 | 34065 | 622 | |
23403 | 23403 | San Diego | San Diego | 73 | 2020-08-15 | 34344 | 626 | |
23342 | 23342 | San Diego | San Diego | 73 | 2020-08-16 | 34678 | 626 | |
23281 | 23281 | San Diego | San Diego | 73 | 2020-08-17 | 34960 | 626 | |
23220 | 23220 | San Diego | San Diego | 73 | 2020-08-18 | 35162 | 633 | |
23159 | 23159 | San Diego | San Diego | 73 | 2020-08-19 | 35376 | 638 | |
23098 | 23098 | San Diego | San Diego | 73 | 2020-08-20 | 35608 | 644 | |
23037 | 23037 | San Diego | San Diego | 73 | 2020-08-21 | 35912 | 652 | |
22976 | 22976 | San Diego | San Diego | 73 | 2020-08-22 | 36203 | 660 | |
22915 | 22915 | San Diego | San Diego | 73 | 2020-08-23 | 36540 | 660 | |
22854 | 22854 | San Diego | San Diego | 73 | 2020-08-24 | 36727 | 660 | |
22793 | 22793 | San Diego | San Diego | 73 | 2020-08-25 | 36994 | 665 | |
22732 | 22732 | San Diego | San Diego | 73 | 2020-08-26 | 37222 | 668 | |
22671 | 22671 | San Diego | San Diego | 73 | 2020-08-27 | 37499 | 673 | |
22610 | 22610 | San Diego | San Diego | 73 | 2020-08-28 | 37784 | 676 | |
22549 | 22549 | San Diego | San Diego | 73 | 2020-08-29 | 38047 | 679 | |
22488 | 22488 | San Diego | San Diego | 73 | 2020-08-30 | 38300 | 682 | |
22427 | 22427 | San Diego | San Diego | 73 | 2020-08-31 | 38604 | 682 | |
22366 | 22366 | San Diego | San Diego | 73 | 2020-09-01 | 38871 | 688 | |
22305 | 22305 | San Diego | San Diego | 73 | 2020-09-02 | 39121 | 695 | |
22244 | 22244 | San Diego | San Diego | 73 | 2020-09-03 | 39446 | 700 | |
22183 | 22183 | San Diego | San Diego | 73 | 2020-09-04 | 39899 | 701 | |
22122 | 22122 | San Diego | San Diego | 73 | 2020-09-05 | 40342 | 704 | |
22000 | 22000 | San Diego | San Diego | 73 | 2020-09-07 | 40650 | 707 | TRUE |
22061 | 22061 | San Diego | San Diego | 73 | 2020-09-06 | 40650 | 707 | |
21939 | 21939 | San Diego | San Diego | 73 | 2020-09-08 | 41077 | 709 |
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 );