ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
772 rows where county = "Jackson" and fips = 47087 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1056075 | 1056075 | 2021-02-22 | Jackson | Tennessee | 47087 | 1245 | 33 |
1052829 | 1052829 | 2021-02-21 | Jackson | Tennessee | 47087 | 1245 | 33 |
1049582 | 1049582 | 2021-02-20 | Jackson | Tennessee | 47087 | 1245 | 33 |
1046335 | 1046335 | 2021-02-19 | Jackson | Tennessee | 47087 | 1245 | 33 |
1043090 | 1043090 | 2021-02-18 | Jackson | Tennessee | 47087 | 1245 | 33 |
1039845 | 1039845 | 2021-02-17 | Jackson | Tennessee | 47087 | 1246 | 33 |
1036600 | 1036600 | 2021-02-16 | Jackson | Tennessee | 47087 | 1244 | 33 |
1033355 | 1033355 | 2021-02-15 | Jackson | Tennessee | 47087 | 1242 | 33 |
1030109 | 1030109 | 2021-02-14 | Jackson | Tennessee | 47087 | 1238 | 33 |
1026862 | 1026862 | 2021-02-13 | Jackson | Tennessee | 47087 | 1236 | 33 |
1023617 | 1023617 | 2021-02-12 | Jackson | Tennessee | 47087 | 1232 | 32 |
1020372 | 1020372 | 2021-02-11 | Jackson | Tennessee | 47087 | 1227 | 31 |
1017127 | 1017127 | 2021-02-10 | Jackson | Tennessee | 47087 | 1207 | 30 |
1013882 | 1013882 | 2021-02-09 | Jackson | Tennessee | 47087 | 1131 | 30 |
1010637 | 1010637 | 2021-02-08 | Jackson | Tennessee | 47087 | 1113 | 27 |
1007391 | 1007391 | 2021-02-07 | Jackson | Tennessee | 47087 | 1110 | 27 |
1004145 | 1004145 | 2021-02-06 | Jackson | Tennessee | 47087 | 1109 | 27 |
1000899 | 1000899 | 2021-02-05 | Jackson | Tennessee | 47087 | 1102 | 27 |
997653 | 997653 | 2021-02-04 | Jackson | Tennessee | 47087 | 1099 | 27 |
994407 | 994407 | 2021-02-03 | Jackson | Tennessee | 47087 | 1096 | 27 |
991161 | 991161 | 2021-02-02 | Jackson | Tennessee | 47087 | 1092 | 25 |
987915 | 987915 | 2021-02-01 | Jackson | Tennessee | 47087 | 1091 | 25 |
984668 | 984668 | 2021-01-31 | Jackson | Tennessee | 47087 | 1089 | 25 |
981421 | 981421 | 2021-01-30 | Jackson | Tennessee | 47087 | 1088 | 25 |
978175 | 978175 | 2021-01-29 | Jackson | Tennessee | 47087 | 1081 | 24 |
974930 | 974930 | 2021-01-28 | Jackson | Tennessee | 47087 | 1074 | 24 |
971685 | 971685 | 2021-01-27 | Jackson | Tennessee | 47087 | 1072 | 24 |
968440 | 968440 | 2021-01-26 | Jackson | Tennessee | 47087 | 1070 | 24 |
965196 | 965196 | 2021-01-25 | Jackson | Tennessee | 47087 | 1066 | 24 |
961951 | 961951 | 2021-01-24 | Jackson | Tennessee | 47087 | 1061 | 23 |
958706 | 958706 | 2021-01-23 | Jackson | Tennessee | 47087 | 1059 | 23 |
955460 | 955460 | 2021-01-22 | Jackson | Tennessee | 47087 | 1057 | 23 |
952215 | 952215 | 2021-01-21 | Jackson | Tennessee | 47087 | 1058 | 23 |
948970 | 948970 | 2021-01-20 | Jackson | Tennessee | 47087 | 1054 | 23 |
945724 | 945724 | 2021-01-19 | Jackson | Tennessee | 47087 | 1043 | 22 |
942477 | 942477 | 2021-01-18 | Jackson | Tennessee | 47087 | 1040 | 21 |
939232 | 939232 | 2021-01-17 | Jackson | Tennessee | 47087 | 1037 | 21 |
935987 | 935987 | 2021-01-16 | Jackson | Tennessee | 47087 | 1034 | 21 |
932742 | 932742 | 2021-01-15 | Jackson | Tennessee | 47087 | 1028 | 21 |
929497 | 929497 | 2021-01-14 | Jackson | Tennessee | 47087 | 1025 | 20 |
926252 | 926252 | 2021-01-13 | Jackson | Tennessee | 47087 | 1023 | 20 |
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 |
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);