ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
339 rows where fips = 6067 sorted by date descending
This data as json, yaml, copyable, CSV (advanced)
Suggested facets: date (date)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
959682 | 959682 | 2021-01-24 | Sacramento | California | 6067 | 83407 | 1157 |
956436 | 956436 | 2021-01-23 | Sacramento | California | 6067 | 82860 | 1157 |
953191 | 953191 | 2021-01-22 | Sacramento | California | 6067 | 82302 | 1157 |
949946 | 949946 | 2021-01-21 | Sacramento | California | 6067 | 81686 | 1145 |
946700 | 946700 | 2021-01-20 | Sacramento | California | 6067 | 81182 | 1128 |
943453 | 943453 | 2021-01-19 | Sacramento | California | 6067 | 80677 | 1111 |
940208 | 940208 | 2021-01-18 | Sacramento | California | 6067 | 80153 | 1080 |
936963 | 936963 | 2021-01-17 | Sacramento | California | 6067 | 79121 | 1080 |
933718 | 933718 | 2021-01-16 | Sacramento | California | 6067 | 80278 | 1080 |
930473 | 930473 | 2021-01-15 | Sacramento | California | 6067 | 79136 | 1080 |
927228 | 927228 | 2021-01-14 | Sacramento | California | 6067 | 78267 | 1062 |
923982 | 923982 | 2021-01-13 | Sacramento | California | 6067 | 77200 | 1044 |
920737 | 920737 | 2021-01-12 | Sacramento | California | 6067 | 76008 | 1031 |
917492 | 917492 | 2021-01-11 | Sacramento | California | 6067 | 75393 | 1015 |
914247 | 914247 | 2021-01-10 | Sacramento | California | 6067 | 74481 | 977 |
911002 | 911002 | 2021-01-09 | Sacramento | California | 6067 | 73244 | 977 |
907757 | 907757 | 2021-01-08 | Sacramento | California | 6067 | 72341 | 977 |
904511 | 904511 | 2021-01-07 | Sacramento | California | 6067 | 71571 | 955 |
901266 | 901266 | 2021-01-06 | Sacramento | California | 6067 | 70676 | 941 |
898021 | 898021 | 2021-01-05 | Sacramento | California | 6067 | 70163 | 917 |
894776 | 894776 | 2021-01-04 | Sacramento | California | 6067 | 69110 | 898 |
891529 | 891529 | 2021-01-03 | Sacramento | California | 6067 | 67809 | 857 |
888282 | 888282 | 2021-01-02 | Sacramento | California | 6067 | 66955 | 857 |
885037 | 885037 | 2021-01-01 | Sacramento | California | 6067 | 65816 | 857 |
881792 | 881792 | 2020-12-31 | Sacramento | California | 6067 | 65540 | 857 |
878547 | 878547 | 2020-12-30 | Sacramento | California | 6067 | 65077 | 844 |
875302 | 875302 | 2020-12-29 | Sacramento | California | 6067 | 64321 | 833 |
872057 | 872057 | 2020-12-28 | Sacramento | California | 6067 | 63415 | 827 |
868812 | 868812 | 2020-12-27 | Sacramento | California | 6067 | 62434 | 809 |
865567 | 865567 | 2020-12-26 | Sacramento | California | 6067 | 61629 | 809 |
862322 | 862322 | 2020-12-25 | Sacramento | California | 6067 | 60595 | 809 |
859077 | 859077 | 2020-12-24 | Sacramento | California | 6067 | 59769 | 809 |
855832 | 855832 | 2020-12-23 | Sacramento | California | 6067 | 58868 | 797 |
852587 | 852587 | 2020-12-22 | Sacramento | California | 6067 | 58000 | 786 |
849342 | 849342 | 2020-12-21 | Sacramento | California | 6067 | 57081 | 774 |
846097 | 846097 | 2020-12-20 | Sacramento | California | 6067 | 55168 | 741 |
842851 | 842851 | 2020-12-19 | Sacramento | California | 6067 | 54002 | 741 |
839606 | 839606 | 2020-12-18 | Sacramento | California | 6067 | 54002 | 741 |
836361 | 836361 | 2020-12-17 | Sacramento | California | 6067 | 53184 | 727 |
833115 | 833115 | 2020-12-16 | Sacramento | California | 6067 | 52181 | 711 |
829868 | 829868 | 2020-12-15 | Sacramento | California | 6067 | 51051 | 699 |
826622 | 826622 | 2020-12-14 | Sacramento | California | 6067 | 50222 | 689 |
823375 | 823375 | 2020-12-13 | Sacramento | California | 6067 | 48318 | 670 |
820129 | 820129 | 2020-12-12 | Sacramento | California | 6067 | 47472 | 670 |
816883 | 816883 | 2020-12-11 | Sacramento | California | 6067 | 47472 | 670 |
813637 | 813637 | 2020-12-10 | Sacramento | California | 6067 | 46478 | 659 |
810393 | 810393 | 2020-12-09 | Sacramento | California | 6067 | 45335 | 646 |
807148 | 807148 | 2020-12-08 | Sacramento | California | 6067 | 44687 | 635 |
803903 | 803903 | 2020-12-07 | Sacramento | California | 6067 | 43425 | 620 |
800657 | 800657 | 2020-12-06 | Sacramento | California | 6067 | 41877 | 614 |
797411 | 797411 | 2020-12-05 | Sacramento | California | 6067 | 41095 | 614 |
794166 | 794166 | 2020-12-04 | Sacramento | California | 6067 | 41095 | 614 |
790920 | 790920 | 2020-12-03 | Sacramento | California | 6067 | 40304 | 603 |
787674 | 787674 | 2020-12-02 | Sacramento | California | 6067 | 39366 | 591 |
784430 | 784430 | 2020-12-01 | Sacramento | California | 6067 | 38998 | 586 |
781185 | 781185 | 2020-11-30 | Sacramento | California | 6067 | 37883 | 581 |
777939 | 777939 | 2020-11-29 | Sacramento | California | 6067 | 36904 | 576 |
774693 | 774693 | 2020-11-28 | Sacramento | California | 6067 | 36629 | 576 |
771448 | 771448 | 2020-11-27 | Sacramento | California | 6067 | 36629 | 576 |
768202 | 768202 | 2020-11-26 | Sacramento | California | 6067 | 35738 | 566 |
764955 | 764955 | 2020-11-25 | Sacramento | California | 6067 | 35738 | 566 |
761709 | 761709 | 2020-11-24 | Sacramento | California | 6067 | 35142 | 557 |
758463 | 758463 | 2020-11-23 | Sacramento | California | 6067 | 34185 | 550 |
755216 | 755216 | 2020-11-22 | Sacramento | California | 6067 | 33132 | 546 |
751969 | 751969 | 2020-11-21 | Sacramento | California | 6067 | 32864 | 546 |
748722 | 748722 | 2020-11-20 | Sacramento | California | 6067 | 32864 | 546 |
745475 | 745475 | 2020-11-19 | Sacramento | California | 6067 | 32410 | 544 |
742228 | 742228 | 2020-11-18 | Sacramento | California | 6067 | 31851 | 536 |
738981 | 738981 | 2020-11-17 | Sacramento | California | 6067 | 31386 | 533 |
735736 | 735736 | 2020-11-16 | Sacramento | California | 6067 | 30998 | 527 |
732490 | 732490 | 2020-11-15 | Sacramento | California | 6067 | 30297 | 520 |
729245 | 729245 | 2020-11-14 | Sacramento | California | 6067 | 29836 | 520 |
726001 | 726001 | 2020-11-13 | Sacramento | California | 6067 | 29836 | 520 |
722757 | 722757 | 2020-11-12 | Sacramento | California | 6067 | 29509 | 517 |
719513 | 719513 | 2020-11-11 | Sacramento | California | 6067 | 29013 | 514 |
716269 | 716269 | 2020-11-10 | Sacramento | California | 6067 | 28720 | 514 |
713025 | 713025 | 2020-11-09 | Sacramento | California | 6067 | 28236 | 513 |
709781 | 709781 | 2020-11-08 | Sacramento | California | 6067 | 27772 | 508 |
706537 | 706537 | 2020-11-07 | Sacramento | California | 6067 | 27529 | 508 |
703294 | 703294 | 2020-11-06 | Sacramento | California | 6067 | 27529 | 508 |
700050 | 700050 | 2020-11-05 | Sacramento | California | 6067 | 27277 | 506 |
696805 | 696805 | 2020-11-04 | Sacramento | California | 6067 | 27042 | 506 |
693562 | 693562 | 2020-11-03 | Sacramento | California | 6067 | 26883 | 504 |
690319 | 690319 | 2020-11-02 | Sacramento | California | 6067 | 26715 | 502 |
687074 | 687074 | 2020-11-01 | Sacramento | California | 6067 | 26315 | 500 |
683829 | 683829 | 2020-10-31 | Sacramento | California | 6067 | 26184 | 500 |
680585 | 680585 | 2020-10-30 | Sacramento | California | 6067 | 26184 | 500 |
677342 | 677342 | 2020-10-29 | Sacramento | California | 6067 | 26017 | 500 |
674098 | 674098 | 2020-10-28 | Sacramento | California | 6067 | 25881 | 499 |
670856 | 670856 | 2020-10-27 | Sacramento | California | 6067 | 25749 | 496 |
667613 | 667613 | 2020-10-26 | Sacramento | California | 6067 | 25600 | 491 |
664367 | 664367 | 2020-10-25 | Sacramento | California | 6067 | 25371 | 484 |
661122 | 661122 | 2020-10-24 | Sacramento | California | 6067 | 25263 | 484 |
657878 | 657878 | 2020-10-23 | Sacramento | California | 6067 | 25263 | 484 |
654633 | 654633 | 2020-10-22 | Sacramento | California | 6067 | 25093 | 482 |
651388 | 651388 | 2020-10-21 | Sacramento | California | 6067 | 24956 | 480 |
648144 | 648144 | 2020-10-20 | Sacramento | California | 6067 | 24810 | 474 |
644899 | 644899 | 2020-10-19 | Sacramento | California | 6067 | 24581 | 471 |
641651 | 641651 | 2020-10-18 | Sacramento | California | 6067 | 24303 | 468 |
638404 | 638404 | 2020-10-17 | Sacramento | California | 6067 | 24191 | 468 |
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]);