ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
775 rows where fips = 47055 and state = "Tennessee" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
955444 | 955444 | 2021-01-22 | Giles | Tennessee | 47055 | 3305 | 74 |
952199 | 952199 | 2021-01-21 | Giles | Tennessee | 47055 | 3286 | 74 |
948954 | 948954 | 2021-01-20 | Giles | Tennessee | 47055 | 3253 | 73 |
945708 | 945708 | 2021-01-19 | Giles | Tennessee | 47055 | 3230 | 72 |
942461 | 942461 | 2021-01-18 | Giles | Tennessee | 47055 | 3217 | 72 |
939216 | 939216 | 2021-01-17 | Giles | Tennessee | 47055 | 3210 | 71 |
935971 | 935971 | 2021-01-16 | Giles | Tennessee | 47055 | 3193 | 71 |
932726 | 932726 | 2021-01-15 | Giles | Tennessee | 47055 | 3173 | 71 |
929481 | 929481 | 2021-01-14 | Giles | Tennessee | 47055 | 3150 | 71 |
926236 | 926236 | 2021-01-13 | Giles | Tennessee | 47055 | 3127 | 70 |
922990 | 922990 | 2021-01-12 | Giles | Tennessee | 47055 | 3111 | 70 |
919745 | 919745 | 2021-01-11 | Giles | Tennessee | 47055 | 3088 | 69 |
916500 | 916500 | 2021-01-10 | Giles | Tennessee | 47055 | 3073 | 68 |
913255 | 913255 | 2021-01-09 | Giles | Tennessee | 47055 | 3042 | 68 |
910010 | 910010 | 2021-01-08 | Giles | Tennessee | 47055 | 3000 | 67 |
906765 | 906765 | 2021-01-07 | Giles | Tennessee | 47055 | 2966 | 65 |
903519 | 903519 | 2021-01-06 | Giles | Tennessee | 47055 | 2918 | 64 |
900274 | 900274 | 2021-01-05 | Giles | Tennessee | 47055 | 2870 | 63 |
897029 | 897029 | 2021-01-04 | Giles | Tennessee | 47055 | 2834 | 63 |
893783 | 893783 | 2021-01-03 | Giles | Tennessee | 47055 | 2797 | 62 |
890537 | 890537 | 2021-01-02 | Giles | Tennessee | 47055 | 2757 | 61 |
887290 | 887290 | 2021-01-01 | Giles | Tennessee | 47055 | 2670 | 60 |
884045 | 884045 | 2020-12-31 | Giles | Tennessee | 47055 | 2670 | 60 |
880800 | 880800 | 2020-12-30 | Giles | Tennessee | 47055 | 2599 | 60 |
877555 | 877555 | 2020-12-29 | Giles | Tennessee | 47055 | 2567 | 60 |
874310 | 874310 | 2020-12-28 | Giles | Tennessee | 47055 | 2554 | 60 |
871065 | 871065 | 2020-12-27 | Giles | Tennessee | 47055 | 2538 | 60 |
867820 | 867820 | 2020-12-26 | Giles | Tennessee | 47055 | 2517 | 60 |
864575 | 864575 | 2020-12-25 | Giles | Tennessee | 47055 | 2484 | 60 |
861330 | 861330 | 2020-12-24 | Giles | Tennessee | 47055 | 2423 | 60 |
858085 | 858085 | 2020-12-23 | Giles | Tennessee | 47055 | 2384 | 59 |
854840 | 854840 | 2020-12-22 | Giles | Tennessee | 47055 | 2353 | 58 |
851595 | 851595 | 2020-12-21 | Giles | Tennessee | 47055 | 2328 | 57 |
848350 | 848350 | 2020-12-20 | Giles | Tennessee | 47055 | 2240 | 56 |
845105 | 845105 | 2020-12-19 | Giles | Tennessee | 47055 | 2162 | 56 |
841859 | 841859 | 2020-12-18 | Giles | Tennessee | 47055 | 2131 | 56 |
838614 | 838614 | 2020-12-17 | Giles | Tennessee | 47055 | 2050 | 56 |
835368 | 835368 | 2020-12-16 | Giles | Tennessee | 47055 | 2014 | 56 |
832122 | 832122 | 2020-12-15 | Giles | Tennessee | 47055 | 1953 | 54 |
828875 | 828875 | 2020-12-14 | Giles | Tennessee | 47055 | 1879 | 53 |
825629 | 825629 | 2020-12-13 | Giles | Tennessee | 47055 | 1842 | 53 |
822382 | 822382 | 2020-12-12 | Giles | Tennessee | 47055 | 1813 | 52 |
819136 | 819136 | 2020-12-11 | Giles | Tennessee | 47055 | 1791 | 52 |
815890 | 815890 | 2020-12-10 | Giles | Tennessee | 47055 | 1752 | 51 |
812644 | 812644 | 2020-12-09 | Giles | Tennessee | 47055 | 1718 | 51 |
809400 | 809400 | 2020-12-08 | Giles | Tennessee | 47055 | 1690 | 51 |
806155 | 806155 | 2020-12-07 | Giles | Tennessee | 47055 | 1626 | 50 |
802910 | 802910 | 2020-12-06 | Giles | Tennessee | 47055 | 1606 | 50 |
799665 | 799665 | 2020-12-05 | Giles | Tennessee | 47055 | 1600 | 50 |
796420 | 796420 | 2020-12-04 | Giles | Tennessee | 47055 | 1589 | 51 |
793175 | 793175 | 2020-12-03 | Giles | Tennessee | 47055 | 1576 | 49 |
789930 | 789930 | 2020-12-02 | Giles | Tennessee | 47055 | 1557 | 49 |
786685 | 786685 | 2020-12-01 | Giles | Tennessee | 47055 | 1533 | 49 |
783441 | 783441 | 2020-11-30 | Giles | Tennessee | 47055 | 1502 | 49 |
780196 | 780196 | 2020-11-29 | Giles | Tennessee | 47055 | 1475 | 49 |
776950 | 776950 | 2020-11-28 | Giles | Tennessee | 47055 | 1469 | 49 |
773705 | 773705 | 2020-11-27 | Giles | Tennessee | 47055 | 1439 | 49 |
770460 | 770460 | 2020-11-26 | Giles | Tennessee | 47055 | 1409 | 49 |
767214 | 767214 | 2020-11-25 | Giles | Tennessee | 47055 | 1385 | 46 |
763969 | 763969 | 2020-11-24 | Giles | Tennessee | 47055 | 1360 | 44 |
760724 | 760724 | 2020-11-23 | Giles | Tennessee | 47055 | 1356 | 43 |
757479 | 757479 | 2020-11-22 | Giles | Tennessee | 47055 | 1342 | 42 |
754232 | 754232 | 2020-11-21 | Giles | Tennessee | 47055 | 1328 | 40 |
750986 | 750986 | 2020-11-20 | Giles | Tennessee | 47055 | 1311 | 40 |
747740 | 747740 | 2020-11-19 | Giles | Tennessee | 47055 | 1300 | 40 |
744494 | 744494 | 2020-11-18 | Giles | Tennessee | 47055 | 1300 | 40 |
741247 | 741247 | 2020-11-17 | Giles | Tennessee | 47055 | 1293 | 40 |
738001 | 738001 | 2020-11-16 | Giles | Tennessee | 47055 | 1282 | 39 |
734757 | 734757 | 2020-11-15 | Giles | Tennessee | 47055 | 1254 | 39 |
731511 | 731511 | 2020-11-14 | Giles | Tennessee | 47055 | 1241 | 39 |
728267 | 728267 | 2020-11-13 | Giles | Tennessee | 47055 | 1208 | 39 |
725023 | 725023 | 2020-11-12 | Giles | Tennessee | 47055 | 1200 | 39 |
721780 | 721780 | 2020-11-11 | Giles | Tennessee | 47055 | 1175 | 39 |
718537 | 718537 | 2020-11-10 | Giles | Tennessee | 47055 | 1152 | 39 |
715294 | 715294 | 2020-11-09 | Giles | Tennessee | 47055 | 1139 | 38 |
712050 | 712050 | 2020-11-08 | Giles | Tennessee | 47055 | 1119 | 38 |
708806 | 708806 | 2020-11-07 | Giles | Tennessee | 47055 | 1112 | 38 |
705563 | 705563 | 2020-11-06 | Giles | Tennessee | 47055 | 1082 | 38 |
702320 | 702320 | 2020-11-05 | Giles | Tennessee | 47055 | 1081 | 38 |
699076 | 699076 | 2020-11-04 | Giles | Tennessee | 47055 | 1076 | 38 |
695833 | 695833 | 2020-11-03 | Giles | Tennessee | 47055 | 1056 | 38 |
692591 | 692591 | 2020-11-02 | Giles | Tennessee | 47055 | 1035 | 38 |
689347 | 689347 | 2020-11-01 | Giles | Tennessee | 47055 | 1027 | 38 |
686102 | 686102 | 2020-10-31 | Giles | Tennessee | 47055 | 1026 | 38 |
682859 | 682859 | 2020-10-30 | Giles | Tennessee | 47055 | 1022 | 38 |
679616 | 679616 | 2020-10-29 | Giles | Tennessee | 47055 | 1007 | 38 |
676373 | 676373 | 2020-10-28 | Giles | Tennessee | 47055 | 994 | 38 |
673130 | 673130 | 2020-10-27 | Giles | Tennessee | 47055 | 986 | 36 |
669888 | 669888 | 2020-10-26 | Giles | Tennessee | 47055 | 983 | 36 |
666644 | 666644 | 2020-10-25 | Giles | Tennessee | 47055 | 969 | 36 |
663399 | 663399 | 2020-10-24 | Giles | Tennessee | 47055 | 951 | 35 |
660155 | 660155 | 2020-10-23 | Giles | Tennessee | 47055 | 937 | 35 |
656911 | 656911 | 2020-10-22 | Giles | Tennessee | 47055 | 921 | 34 |
653666 | 653666 | 2020-10-21 | Giles | Tennessee | 47055 | 911 | 34 |
650421 | 650421 | 2020-10-20 | Giles | Tennessee | 47055 | 901 | 34 |
647177 | 647177 | 2020-10-19 | Giles | Tennessee | 47055 | 892 | 34 |
643931 | 643931 | 2020-10-18 | Giles | Tennessee | 47055 | 880 | 31 |
640683 | 640683 | 2020-10-17 | Giles | Tennessee | 47055 | 869 | 31 |
637437 | 637437 | 2020-10-16 | Giles | Tennessee | 47055 | 855 | 31 |
634191 | 634191 | 2020-10-15 | Giles | Tennessee | 47055 | 850 | 30 |
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);