ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
813 rows where fips = 6067 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
920657 | 920657 | 2021-01-12 | Sacramento | California | 6067 | 76008 | 1031 |
917412 | 917412 | 2021-01-11 | Sacramento | California | 6067 | 75393 | 1015 |
914167 | 914167 | 2021-01-10 | Sacramento | California | 6067 | 74481 | 977 |
910922 | 910922 | 2021-01-09 | Sacramento | California | 6067 | 73244 | 977 |
907677 | 907677 | 2021-01-08 | Sacramento | California | 6067 | 72341 | 977 |
904431 | 904431 | 2021-01-07 | Sacramento | California | 6067 | 71571 | 955 |
901186 | 901186 | 2021-01-06 | Sacramento | California | 6067 | 70676 | 941 |
897941 | 897941 | 2021-01-05 | Sacramento | California | 6067 | 70163 | 917 |
894696 | 894696 | 2021-01-04 | Sacramento | California | 6067 | 69110 | 898 |
891449 | 891449 | 2021-01-03 | Sacramento | California | 6067 | 67809 | 857 |
888202 | 888202 | 2021-01-02 | Sacramento | California | 6067 | 66955 | 857 |
884957 | 884957 | 2021-01-01 | Sacramento | California | 6067 | 65816 | 857 |
881712 | 881712 | 2020-12-31 | Sacramento | California | 6067 | 65540 | 857 |
878467 | 878467 | 2020-12-30 | Sacramento | California | 6067 | 65077 | 844 |
875222 | 875222 | 2020-12-29 | Sacramento | California | 6067 | 64321 | 833 |
871977 | 871977 | 2020-12-28 | Sacramento | California | 6067 | 63415 | 827 |
868732 | 868732 | 2020-12-27 | Sacramento | California | 6067 | 62434 | 809 |
865487 | 865487 | 2020-12-26 | Sacramento | California | 6067 | 61629 | 809 |
862242 | 862242 | 2020-12-25 | Sacramento | California | 6067 | 60595 | 809 |
858997 | 858997 | 2020-12-24 | Sacramento | California | 6067 | 59769 | 809 |
855752 | 855752 | 2020-12-23 | Sacramento | California | 6067 | 58868 | 797 |
852507 | 852507 | 2020-12-22 | Sacramento | California | 6067 | 58000 | 786 |
849262 | 849262 | 2020-12-21 | Sacramento | California | 6067 | 57081 | 774 |
846017 | 846017 | 2020-12-20 | Sacramento | California | 6067 | 55168 | 741 |
842771 | 842771 | 2020-12-19 | Sacramento | California | 6067 | 54002 | 741 |
839526 | 839526 | 2020-12-18 | Sacramento | California | 6067 | 54002 | 741 |
836281 | 836281 | 2020-12-17 | Sacramento | California | 6067 | 53184 | 727 |
833035 | 833035 | 2020-12-16 | Sacramento | California | 6067 | 52181 | 711 |
829788 | 829788 | 2020-12-15 | Sacramento | California | 6067 | 51051 | 699 |
826542 | 826542 | 2020-12-14 | Sacramento | California | 6067 | 50222 | 689 |
823295 | 823295 | 2020-12-13 | Sacramento | California | 6067 | 48318 | 670 |
820049 | 820049 | 2020-12-12 | Sacramento | California | 6067 | 47472 | 670 |
816803 | 816803 | 2020-12-11 | Sacramento | California | 6067 | 47472 | 670 |
813557 | 813557 | 2020-12-10 | Sacramento | California | 6067 | 46478 | 659 |
810313 | 810313 | 2020-12-09 | Sacramento | California | 6067 | 45335 | 646 |
807068 | 807068 | 2020-12-08 | Sacramento | California | 6067 | 44687 | 635 |
803823 | 803823 | 2020-12-07 | Sacramento | California | 6067 | 43425 | 620 |
800578 | 800578 | 2020-12-06 | Sacramento | California | 6067 | 41877 | 614 |
797333 | 797333 | 2020-12-05 | Sacramento | California | 6067 | 41095 | 614 |
794088 | 794088 | 2020-12-04 | Sacramento | California | 6067 | 41095 | 614 |
790843 | 790843 | 2020-12-03 | Sacramento | California | 6067 | 40304 | 603 |
787598 | 787598 | 2020-12-02 | Sacramento | California | 6067 | 39366 | 591 |
784354 | 784354 | 2020-12-01 | Sacramento | California | 6067 | 38998 | 586 |
781109 | 781109 | 2020-11-30 | Sacramento | California | 6067 | 37883 | 581 |
777863 | 777863 | 2020-11-29 | Sacramento | California | 6067 | 36904 | 576 |
774618 | 774618 | 2020-11-28 | Sacramento | California | 6067 | 36629 | 576 |
771373 | 771373 | 2020-11-27 | Sacramento | California | 6067 | 36629 | 576 |
768128 | 768128 | 2020-11-26 | Sacramento | California | 6067 | 35738 | 566 |
764882 | 764882 | 2020-11-25 | Sacramento | California | 6067 | 35738 | 566 |
761637 | 761637 | 2020-11-24 | Sacramento | California | 6067 | 35142 | 557 |
758392 | 758392 | 2020-11-23 | Sacramento | California | 6067 | 34185 | 550 |
755145 | 755145 | 2020-11-22 | Sacramento | California | 6067 | 33132 | 546 |
751899 | 751899 | 2020-11-21 | Sacramento | California | 6067 | 32864 | 546 |
748653 | 748653 | 2020-11-20 | Sacramento | California | 6067 | 32864 | 546 |
745407 | 745407 | 2020-11-19 | Sacramento | California | 6067 | 32410 | 544 |
742160 | 742160 | 2020-11-18 | Sacramento | California | 6067 | 31851 | 536 |
738913 | 738913 | 2020-11-17 | Sacramento | California | 6067 | 31386 | 533 |
735669 | 735669 | 2020-11-16 | Sacramento | California | 6067 | 30998 | 527 |
732423 | 732423 | 2020-11-15 | Sacramento | California | 6067 | 30297 | 520 |
729178 | 729178 | 2020-11-14 | Sacramento | California | 6067 | 29836 | 520 |
725935 | 725935 | 2020-11-13 | Sacramento | California | 6067 | 29836 | 520 |
722692 | 722692 | 2020-11-12 | Sacramento | California | 6067 | 29509 | 517 |
719449 | 719449 | 2020-11-11 | Sacramento | California | 6067 | 29013 | 514 |
716206 | 716206 | 2020-11-10 | Sacramento | California | 6067 | 28720 | 514 |
712962 | 712962 | 2020-11-09 | Sacramento | California | 6067 | 28236 | 513 |
709718 | 709718 | 2020-11-08 | Sacramento | California | 6067 | 27772 | 508 |
706474 | 706474 | 2020-11-07 | Sacramento | California | 6067 | 27529 | 508 |
703231 | 703231 | 2020-11-06 | Sacramento | California | 6067 | 27529 | 508 |
699988 | 699988 | 2020-11-05 | Sacramento | California | 6067 | 27277 | 506 |
696744 | 696744 | 2020-11-04 | Sacramento | California | 6067 | 27042 | 506 |
693502 | 693502 | 2020-11-03 | Sacramento | California | 6067 | 26883 | 504 |
690259 | 690259 | 2020-11-02 | Sacramento | California | 6067 | 26715 | 502 |
687014 | 687014 | 2020-11-01 | Sacramento | California | 6067 | 26315 | 500 |
683770 | 683770 | 2020-10-31 | Sacramento | California | 6067 | 26184 | 500 |
680527 | 680527 | 2020-10-30 | Sacramento | California | 6067 | 26184 | 500 |
677284 | 677284 | 2020-10-29 | Sacramento | California | 6067 | 26017 | 500 |
674041 | 674041 | 2020-10-28 | Sacramento | California | 6067 | 25881 | 499 |
670799 | 670799 | 2020-10-27 | Sacramento | California | 6067 | 25749 | 496 |
667556 | 667556 | 2020-10-26 | Sacramento | California | 6067 | 25600 | 491 |
664311 | 664311 | 2020-10-25 | Sacramento | California | 6067 | 25371 | 484 |
661067 | 661067 | 2020-10-24 | Sacramento | California | 6067 | 25263 | 484 |
657823 | 657823 | 2020-10-23 | Sacramento | California | 6067 | 25263 | 484 |
654578 | 654578 | 2020-10-22 | Sacramento | California | 6067 | 25093 | 482 |
651333 | 651333 | 2020-10-21 | Sacramento | California | 6067 | 24956 | 480 |
648089 | 648089 | 2020-10-20 | Sacramento | California | 6067 | 24810 | 474 |
644844 | 644844 | 2020-10-19 | Sacramento | California | 6067 | 24581 | 471 |
641596 | 641596 | 2020-10-18 | Sacramento | California | 6067 | 24303 | 468 |
638349 | 638349 | 2020-10-17 | Sacramento | California | 6067 | 24191 | 468 |
635104 | 635104 | 2020-10-16 | Sacramento | California | 6067 | 24191 | 468 |
631858 | 631858 | 2020-10-15 | Sacramento | California | 6067 | 24101 | 464 |
628614 | 628614 | 2020-10-14 | Sacramento | California | 6067 | 24059 | 462 |
625371 | 625371 | 2020-10-13 | Sacramento | California | 6067 | 23968 | 458 |
622128 | 622128 | 2020-10-12 | Sacramento | California | 6067 | 23849 | 458 |
618885 | 618885 | 2020-10-11 | Sacramento | California | 6067 | 23688 | 450 |
615643 | 615643 | 2020-10-10 | Sacramento | California | 6067 | 23648 | 450 |
612402 | 612402 | 2020-10-09 | Sacramento | California | 6067 | 23648 | 450 |
609160 | 609160 | 2020-10-08 | Sacramento | California | 6067 | 23522 | 447 |
605917 | 605917 | 2020-10-07 | Sacramento | California | 6067 | 23419 | 445 |
602675 | 602675 | 2020-10-06 | Sacramento | California | 6067 | 23362 | 437 |
599432 | 599432 | 2020-10-05 | Sacramento | California | 6067 | 23244 | 432 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE [ny_times_us_counties] ( [date] TEXT, [county] TEXT, [state] TEXT, [fips] INTEGER, [cases] INTEGER, [deaths] INTEGER ); CREATE INDEX [idx_ny_times_us_counties_state] ON [ny_times_us_counties] ([state]); CREATE INDEX [idx_ny_times_us_counties_county] ON [ny_times_us_counties] ([county]); CREATE INDEX [idx_ny_times_us_counties_fips] ON [ny_times_us_counties] ([fips]); CREATE INDEX [idx_ny_times_us_counties_date] ON [ny_times_us_counties] ([date] desc);