ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
786 rows where fips = 47045 and state = "Tennessee" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
955439 | 955439 | 2021-01-22 | Dyer | Tennessee | 47045 | 4833 | 86 |
952194 | 952194 | 2021-01-21 | Dyer | Tennessee | 47045 | 4816 | 87 |
948949 | 948949 | 2021-01-20 | Dyer | Tennessee | 47045 | 4786 | 83 |
945703 | 945703 | 2021-01-19 | Dyer | Tennessee | 47045 | 4772 | 82 |
942456 | 942456 | 2021-01-18 | Dyer | Tennessee | 47045 | 4749 | 82 |
939211 | 939211 | 2021-01-17 | Dyer | Tennessee | 47045 | 4736 | 82 |
935966 | 935966 | 2021-01-16 | Dyer | Tennessee | 47045 | 4715 | 82 |
932721 | 932721 | 2021-01-15 | Dyer | Tennessee | 47045 | 4692 | 81 |
929476 | 929476 | 2021-01-14 | Dyer | Tennessee | 47045 | 4664 | 81 |
926231 | 926231 | 2021-01-13 | Dyer | Tennessee | 47045 | 4642 | 81 |
922985 | 922985 | 2021-01-12 | Dyer | Tennessee | 47045 | 4609 | 81 |
919740 | 919740 | 2021-01-11 | Dyer | Tennessee | 47045 | 4582 | 79 |
916495 | 916495 | 2021-01-10 | Dyer | Tennessee | 47045 | 4571 | 79 |
913250 | 913250 | 2021-01-09 | Dyer | Tennessee | 47045 | 4531 | 79 |
910005 | 910005 | 2021-01-08 | Dyer | Tennessee | 47045 | 4506 | 79 |
906760 | 906760 | 2021-01-07 | Dyer | Tennessee | 47045 | 4478 | 79 |
903514 | 903514 | 2021-01-06 | Dyer | Tennessee | 47045 | 4432 | 75 |
900269 | 900269 | 2021-01-05 | Dyer | Tennessee | 47045 | 4407 | 77 |
897024 | 897024 | 2021-01-04 | Dyer | Tennessee | 47045 | 4368 | 72 |
893778 | 893778 | 2021-01-03 | Dyer | Tennessee | 47045 | 4359 | 70 |
890532 | 890532 | 2021-01-02 | Dyer | Tennessee | 47045 | 4342 | 70 |
887285 | 887285 | 2021-01-01 | Dyer | Tennessee | 47045 | 4254 | 70 |
884040 | 884040 | 2020-12-31 | Dyer | Tennessee | 47045 | 4254 | 70 |
880795 | 880795 | 2020-12-30 | Dyer | Tennessee | 47045 | 4229 | 70 |
877550 | 877550 | 2020-12-29 | Dyer | Tennessee | 47045 | 4172 | 70 |
874305 | 874305 | 2020-12-28 | Dyer | Tennessee | 47045 | 4138 | 68 |
871060 | 871060 | 2020-12-27 | Dyer | Tennessee | 47045 | 4114 | 67 |
867815 | 867815 | 2020-12-26 | Dyer | Tennessee | 47045 | 4089 | 67 |
864570 | 864570 | 2020-12-25 | Dyer | Tennessee | 47045 | 4071 | 67 |
861325 | 861325 | 2020-12-24 | Dyer | Tennessee | 47045 | 4047 | 67 |
858080 | 858080 | 2020-12-23 | Dyer | Tennessee | 47045 | 4033 | 66 |
854835 | 854835 | 2020-12-22 | Dyer | Tennessee | 47045 | 3991 | 66 |
851590 | 851590 | 2020-12-21 | Dyer | Tennessee | 47045 | 3965 | 65 |
848345 | 848345 | 2020-12-20 | Dyer | Tennessee | 47045 | 3934 | 65 |
845100 | 845100 | 2020-12-19 | Dyer | Tennessee | 47045 | 3894 | 65 |
841854 | 841854 | 2020-12-18 | Dyer | Tennessee | 47045 | 3883 | 64 |
838609 | 838609 | 2020-12-17 | Dyer | Tennessee | 47045 | 3840 | 63 |
835363 | 835363 | 2020-12-16 | Dyer | Tennessee | 47045 | 3792 | 63 |
832117 | 832117 | 2020-12-15 | Dyer | Tennessee | 47045 | 3724 | 61 |
828870 | 828870 | 2020-12-14 | Dyer | Tennessee | 47045 | 3691 | 60 |
825624 | 825624 | 2020-12-13 | Dyer | Tennessee | 47045 | 3648 | 60 |
822377 | 822377 | 2020-12-12 | Dyer | Tennessee | 47045 | 3605 | 61 |
819131 | 819131 | 2020-12-11 | Dyer | Tennessee | 47045 | 3570 | 61 |
815885 | 815885 | 2020-12-10 | Dyer | Tennessee | 47045 | 3531 | 59 |
812639 | 812639 | 2020-12-09 | Dyer | Tennessee | 47045 | 3496 | 55 |
809395 | 809395 | 2020-12-08 | Dyer | Tennessee | 47045 | 3454 | 54 |
806150 | 806150 | 2020-12-07 | Dyer | Tennessee | 47045 | 3431 | 53 |
802905 | 802905 | 2020-12-06 | Dyer | Tennessee | 47045 | 3391 | 52 |
799660 | 799660 | 2020-12-05 | Dyer | Tennessee | 47045 | 3363 | 52 |
796415 | 796415 | 2020-12-04 | Dyer | Tennessee | 47045 | 3335 | 52 |
793170 | 793170 | 2020-12-03 | Dyer | Tennessee | 47045 | 3326 | 52 |
789925 | 789925 | 2020-12-02 | Dyer | Tennessee | 47045 | 3293 | 52 |
786680 | 786680 | 2020-12-01 | Dyer | Tennessee | 47045 | 3283 | 52 |
783436 | 783436 | 2020-11-30 | Dyer | Tennessee | 47045 | 3254 | 51 |
780191 | 780191 | 2020-11-29 | Dyer | Tennessee | 47045 | 3220 | 51 |
776945 | 776945 | 2020-11-28 | Dyer | Tennessee | 47045 | 3207 | 51 |
773700 | 773700 | 2020-11-27 | Dyer | Tennessee | 47045 | 3160 | 51 |
770455 | 770455 | 2020-11-26 | Dyer | Tennessee | 47045 | 3147 | 51 |
767209 | 767209 | 2020-11-25 | Dyer | Tennessee | 47045 | 3123 | 50 |
763964 | 763964 | 2020-11-24 | Dyer | Tennessee | 47045 | 3093 | 49 |
760719 | 760719 | 2020-11-23 | Dyer | Tennessee | 47045 | 3086 | 49 |
757474 | 757474 | 2020-11-22 | Dyer | Tennessee | 47045 | 3071 | 49 |
754227 | 754227 | 2020-11-21 | Dyer | Tennessee | 47045 | 3036 | 49 |
750981 | 750981 | 2020-11-20 | Dyer | Tennessee | 47045 | 3004 | 49 |
747735 | 747735 | 2020-11-19 | Dyer | Tennessee | 47045 | 2972 | 48 |
744489 | 744489 | 2020-11-18 | Dyer | Tennessee | 47045 | 2921 | 48 |
741242 | 741242 | 2020-11-17 | Dyer | Tennessee | 47045 | 2886 | 47 |
737996 | 737996 | 2020-11-16 | Dyer | Tennessee | 47045 | 2878 | 47 |
734752 | 734752 | 2020-11-15 | Dyer | Tennessee | 47045 | 2826 | 47 |
731506 | 731506 | 2020-11-14 | Dyer | Tennessee | 47045 | 2803 | 47 |
728262 | 728262 | 2020-11-13 | Dyer | Tennessee | 47045 | 2780 | 45 |
725018 | 725018 | 2020-11-12 | Dyer | Tennessee | 47045 | 2734 | 44 |
721775 | 721775 | 2020-11-11 | Dyer | Tennessee | 47045 | 2698 | 44 |
718532 | 718532 | 2020-11-10 | Dyer | Tennessee | 47045 | 2672 | 42 |
715289 | 715289 | 2020-11-09 | Dyer | Tennessee | 47045 | 2648 | 39 |
712045 | 712045 | 2020-11-08 | Dyer | Tennessee | 47045 | 2607 | 39 |
708801 | 708801 | 2020-11-07 | Dyer | Tennessee | 47045 | 2551 | 39 |
705558 | 705558 | 2020-11-06 | Dyer | Tennessee | 47045 | 2505 | 39 |
702315 | 702315 | 2020-11-05 | Dyer | Tennessee | 47045 | 2502 | 38 |
699071 | 699071 | 2020-11-04 | Dyer | Tennessee | 47045 | 2480 | 38 |
695828 | 695828 | 2020-11-03 | Dyer | Tennessee | 47045 | 2440 | 38 |
692586 | 692586 | 2020-11-02 | Dyer | Tennessee | 47045 | 2431 | 38 |
689342 | 689342 | 2020-11-01 | Dyer | Tennessee | 47045 | 2398 | 38 |
686097 | 686097 | 2020-10-31 | Dyer | Tennessee | 47045 | 2392 | 38 |
682854 | 682854 | 2020-10-30 | Dyer | Tennessee | 47045 | 2363 | 38 |
679611 | 679611 | 2020-10-29 | Dyer | Tennessee | 47045 | 2336 | 38 |
676368 | 676368 | 2020-10-28 | Dyer | Tennessee | 47045 | 2324 | 38 |
673125 | 673125 | 2020-10-27 | Dyer | Tennessee | 47045 | 2285 | 35 |
669883 | 669883 | 2020-10-26 | Dyer | Tennessee | 47045 | 2247 | 32 |
666639 | 666639 | 2020-10-25 | Dyer | Tennessee | 47045 | 2237 | 32 |
663394 | 663394 | 2020-10-24 | Dyer | Tennessee | 47045 | 2189 | 30 |
660150 | 660150 | 2020-10-23 | Dyer | Tennessee | 47045 | 2163 | 29 |
656906 | 656906 | 2020-10-22 | Dyer | Tennessee | 47045 | 2096 | 27 |
653661 | 653661 | 2020-10-21 | Dyer | Tennessee | 47045 | 2071 | 26 |
650416 | 650416 | 2020-10-20 | Dyer | Tennessee | 47045 | 2037 | 26 |
647172 | 647172 | 2020-10-19 | Dyer | Tennessee | 47045 | 2023 | 26 |
643926 | 643926 | 2020-10-18 | Dyer | Tennessee | 47045 | 1995 | 26 |
640678 | 640678 | 2020-10-17 | Dyer | Tennessee | 47045 | 1909 | 26 |
637432 | 637432 | 2020-10-16 | Dyer | Tennessee | 47045 | 1881 | 24 |
634186 | 634186 | 2020-10-15 | Dyer | Tennessee | 47045 | 1874 | 24 |
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);