ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
772 rows where county = "Jackson" and state = "Tennessee" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
923006 | 923006 | 2021-01-12 | Jackson | Tennessee | 47087 | 1020 | 20 |
919761 | 919761 | 2021-01-11 | Jackson | Tennessee | 47087 | 1019 | 20 |
916516 | 916516 | 2021-01-10 | Jackson | Tennessee | 47087 | 1017 | 20 |
913271 | 913271 | 2021-01-09 | Jackson | Tennessee | 47087 | 1007 | 20 |
910026 | 910026 | 2021-01-08 | Jackson | Tennessee | 47087 | 1002 | 20 |
906781 | 906781 | 2021-01-07 | Jackson | Tennessee | 47087 | 991 | 20 |
903535 | 903535 | 2021-01-06 | Jackson | Tennessee | 47087 | 987 | 20 |
900290 | 900290 | 2021-01-05 | Jackson | Tennessee | 47087 | 986 | 20 |
897045 | 897045 | 2021-01-04 | Jackson | Tennessee | 47087 | 974 | 20 |
893799 | 893799 | 2021-01-03 | Jackson | Tennessee | 47087 | 976 | 19 |
890553 | 890553 | 2021-01-02 | Jackson | Tennessee | 47087 | 970 | 19 |
887306 | 887306 | 2021-01-01 | Jackson | Tennessee | 47087 | 948 | 19 |
884061 | 884061 | 2020-12-31 | Jackson | Tennessee | 47087 | 948 | 19 |
880816 | 880816 | 2020-12-30 | Jackson | Tennessee | 47087 | 940 | 19 |
877571 | 877571 | 2020-12-29 | Jackson | Tennessee | 47087 | 932 | 19 |
874326 | 874326 | 2020-12-28 | Jackson | Tennessee | 47087 | 932 | 19 |
871081 | 871081 | 2020-12-27 | Jackson | Tennessee | 47087 | 929 | 18 |
867836 | 867836 | 2020-12-26 | Jackson | Tennessee | 47087 | 924 | 18 |
864591 | 864591 | 2020-12-25 | Jackson | Tennessee | 47087 | 923 | 18 |
861346 | 861346 | 2020-12-24 | Jackson | Tennessee | 47087 | 912 | 18 |
858101 | 858101 | 2020-12-23 | Jackson | Tennessee | 47087 | 907 | 18 |
854856 | 854856 | 2020-12-22 | Jackson | Tennessee | 47087 | 898 | 18 |
851611 | 851611 | 2020-12-21 | Jackson | Tennessee | 47087 | 891 | 18 |
848366 | 848366 | 2020-12-20 | Jackson | Tennessee | 47087 | 883 | 18 |
845121 | 845121 | 2020-12-19 | Jackson | Tennessee | 47087 | 873 | 18 |
841875 | 841875 | 2020-12-18 | Jackson | Tennessee | 47087 | 867 | 18 |
838630 | 838630 | 2020-12-17 | Jackson | Tennessee | 47087 | 854 | 18 |
835384 | 835384 | 2020-12-16 | Jackson | Tennessee | 47087 | 845 | 17 |
832138 | 832138 | 2020-12-15 | Jackson | Tennessee | 47087 | 840 | 17 |
828891 | 828891 | 2020-12-14 | Jackson | Tennessee | 47087 | 835 | 17 |
825645 | 825645 | 2020-12-13 | Jackson | Tennessee | 47087 | 815 | 17 |
822398 | 822398 | 2020-12-12 | Jackson | Tennessee | 47087 | 806 | 17 |
819152 | 819152 | 2020-12-11 | Jackson | Tennessee | 47087 | 793 | 17 |
815906 | 815906 | 2020-12-10 | Jackson | Tennessee | 47087 | 789 | 17 |
812660 | 812660 | 2020-12-09 | Jackson | Tennessee | 47087 | 785 | 17 |
809416 | 809416 | 2020-12-08 | Jackson | Tennessee | 47087 | 766 | 11 |
806171 | 806171 | 2020-12-07 | Jackson | Tennessee | 47087 | 755 | 11 |
802926 | 802926 | 2020-12-06 | Jackson | Tennessee | 47087 | 749 | 11 |
799681 | 799681 | 2020-12-05 | Jackson | Tennessee | 47087 | 740 | 11 |
796436 | 796436 | 2020-12-04 | Jackson | Tennessee | 47087 | 728 | 11 |
793191 | 793191 | 2020-12-03 | Jackson | Tennessee | 47087 | 725 | 10 |
789946 | 789946 | 2020-12-02 | Jackson | Tennessee | 47087 | 720 | 10 |
786701 | 786701 | 2020-12-01 | Jackson | Tennessee | 47087 | 712 | 10 |
783457 | 783457 | 2020-11-30 | Jackson | Tennessee | 47087 | 694 | 10 |
780212 | 780212 | 2020-11-29 | Jackson | Tennessee | 47087 | 684 | 10 |
776966 | 776966 | 2020-11-28 | Jackson | Tennessee | 47087 | 684 | 10 |
773721 | 773721 | 2020-11-27 | Jackson | Tennessee | 47087 | 675 | 10 |
770476 | 770476 | 2020-11-26 | Jackson | Tennessee | 47087 | 671 | 10 |
767230 | 767230 | 2020-11-25 | Jackson | Tennessee | 47087 | 669 | 10 |
763985 | 763985 | 2020-11-24 | Jackson | Tennessee | 47087 | 664 | 10 |
760740 | 760740 | 2020-11-23 | Jackson | Tennessee | 47087 | 660 | 10 |
757495 | 757495 | 2020-11-22 | Jackson | Tennessee | 47087 | 657 | 9 |
754248 | 754248 | 2020-11-21 | Jackson | Tennessee | 47087 | 652 | 9 |
751002 | 751002 | 2020-11-20 | Jackson | Tennessee | 47087 | 650 | 9 |
747756 | 747756 | 2020-11-19 | Jackson | Tennessee | 47087 | 639 | 9 |
744510 | 744510 | 2020-11-18 | Jackson | Tennessee | 47087 | 634 | 9 |
741263 | 741263 | 2020-11-17 | Jackson | Tennessee | 47087 | 629 | 7 |
738017 | 738017 | 2020-11-16 | Jackson | Tennessee | 47087 | 627 | 7 |
734773 | 734773 | 2020-11-15 | Jackson | Tennessee | 47087 | 611 | 7 |
731527 | 731527 | 2020-11-14 | Jackson | Tennessee | 47087 | 598 | 7 |
728283 | 728283 | 2020-11-13 | Jackson | Tennessee | 47087 | 596 | 7 |
725039 | 725039 | 2020-11-12 | Jackson | Tennessee | 47087 | 588 | 7 |
721796 | 721796 | 2020-11-11 | Jackson | Tennessee | 47087 | 555 | 7 |
718553 | 718553 | 2020-11-10 | Jackson | Tennessee | 47087 | 542 | 7 |
715310 | 715310 | 2020-11-09 | Jackson | Tennessee | 47087 | 533 | 7 |
712066 | 712066 | 2020-11-08 | Jackson | Tennessee | 47087 | 529 | 7 |
708822 | 708822 | 2020-11-07 | Jackson | Tennessee | 47087 | 517 | 7 |
705579 | 705579 | 2020-11-06 | Jackson | Tennessee | 47087 | 511 | 7 |
702336 | 702336 | 2020-11-05 | Jackson | Tennessee | 47087 | 501 | 7 |
699092 | 699092 | 2020-11-04 | Jackson | Tennessee | 47087 | 501 | 7 |
695849 | 695849 | 2020-11-03 | Jackson | Tennessee | 47087 | 490 | 7 |
692607 | 692607 | 2020-11-02 | Jackson | Tennessee | 47087 | 488 | 8 |
689363 | 689363 | 2020-11-01 | Jackson | Tennessee | 47087 | 484 | 8 |
686118 | 686118 | 2020-10-31 | Jackson | Tennessee | 47087 | 483 | 8 |
682875 | 682875 | 2020-10-30 | Jackson | Tennessee | 47087 | 477 | 8 |
679632 | 679632 | 2020-10-29 | Jackson | Tennessee | 47087 | 471 | 6 |
676389 | 676389 | 2020-10-28 | Jackson | Tennessee | 47087 | 468 | 6 |
673146 | 673146 | 2020-10-27 | Jackson | Tennessee | 47087 | 459 | 6 |
669904 | 669904 | 2020-10-26 | Jackson | Tennessee | 47087 | 453 | 5 |
666660 | 666660 | 2020-10-25 | Jackson | Tennessee | 47087 | 452 | 5 |
663415 | 663415 | 2020-10-24 | Jackson | Tennessee | 47087 | 452 | 5 |
660171 | 660171 | 2020-10-23 | Jackson | Tennessee | 47087 | 446 | 5 |
656927 | 656927 | 2020-10-22 | Jackson | Tennessee | 47087 | 434 | 5 |
653682 | 653682 | 2020-10-21 | Jackson | Tennessee | 47087 | 422 | 5 |
650437 | 650437 | 2020-10-20 | Jackson | Tennessee | 47087 | 422 | 5 |
647193 | 647193 | 2020-10-19 | Jackson | Tennessee | 47087 | 416 | 5 |
643947 | 643947 | 2020-10-18 | Jackson | Tennessee | 47087 | 415 | 5 |
640699 | 640699 | 2020-10-17 | Jackson | Tennessee | 47087 | 413 | 5 |
637453 | 637453 | 2020-10-16 | Jackson | Tennessee | 47087 | 406 | 5 |
634207 | 634207 | 2020-10-15 | Jackson | Tennessee | 47087 | 403 | 5 |
630962 | 630962 | 2020-10-14 | Jackson | Tennessee | 47087 | 399 | 5 |
627718 | 627718 | 2020-10-13 | Jackson | Tennessee | 47087 | 395 | 5 |
624476 | 624476 | 2020-10-12 | Jackson | Tennessee | 47087 | 391 | 5 |
621233 | 621233 | 2020-10-11 | Jackson | Tennessee | 47087 | 385 | 5 |
617990 | 617990 | 2020-10-10 | Jackson | Tennessee | 47087 | 382 | 5 |
614748 | 614748 | 2020-10-09 | Jackson | Tennessee | 47087 | 377 | 5 |
611507 | 611507 | 2020-10-08 | Jackson | Tennessee | 47087 | 373 | 5 |
608265 | 608265 | 2020-10-07 | Jackson | Tennessee | 47087 | 374 | 5 |
605022 | 605022 | 2020-10-06 | Jackson | Tennessee | 47087 | 368 | 5 |
601780 | 601780 | 2020-10-05 | Jackson | Tennessee | 47087 | 362 | 5 |
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);