ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
785 rows where fips = 47043 and state = "Tennessee" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
955438 | 955438 | 2021-01-22 | Dickson | Tennessee | 47043 | 5526 | 82 |
952193 | 952193 | 2021-01-21 | Dickson | Tennessee | 47043 | 5495 | 80 |
948948 | 948948 | 2021-01-20 | Dickson | Tennessee | 47043 | 5435 | 79 |
945702 | 945702 | 2021-01-19 | Dickson | Tennessee | 47043 | 5404 | 79 |
942455 | 942455 | 2021-01-18 | Dickson | Tennessee | 47043 | 5363 | 78 |
939210 | 939210 | 2021-01-17 | Dickson | Tennessee | 47043 | 5346 | 78 |
935965 | 935965 | 2021-01-16 | Dickson | Tennessee | 47043 | 5326 | 77 |
932720 | 932720 | 2021-01-15 | Dickson | Tennessee | 47043 | 5292 | 77 |
929475 | 929475 | 2021-01-14 | Dickson | Tennessee | 47043 | 5247 | 77 |
926230 | 926230 | 2021-01-13 | Dickson | Tennessee | 47043 | 5196 | 75 |
922984 | 922984 | 2021-01-12 | Dickson | Tennessee | 47043 | 5156 | 75 |
919739 | 919739 | 2021-01-11 | Dickson | Tennessee | 47043 | 5133 | 74 |
916494 | 916494 | 2021-01-10 | Dickson | Tennessee | 47043 | 5120 | 74 |
913249 | 913249 | 2021-01-09 | Dickson | Tennessee | 47043 | 5083 | 72 |
910004 | 910004 | 2021-01-08 | Dickson | Tennessee | 47043 | 5041 | 70 |
906759 | 906759 | 2021-01-07 | Dickson | Tennessee | 47043 | 4977 | 68 |
903513 | 903513 | 2021-01-06 | Dickson | Tennessee | 47043 | 4927 | 68 |
900268 | 900268 | 2021-01-05 | Dickson | Tennessee | 47043 | 4859 | 65 |
897023 | 897023 | 2021-01-04 | Dickson | Tennessee | 47043 | 4828 | 63 |
893777 | 893777 | 2021-01-03 | Dickson | Tennessee | 47043 | 4803 | 61 |
890531 | 890531 | 2021-01-02 | Dickson | Tennessee | 47043 | 4770 | 61 |
887284 | 887284 | 2021-01-01 | Dickson | Tennessee | 47043 | 4624 | 59 |
884039 | 884039 | 2020-12-31 | Dickson | Tennessee | 47043 | 4624 | 59 |
880794 | 880794 | 2020-12-30 | Dickson | Tennessee | 47043 | 4593 | 59 |
877549 | 877549 | 2020-12-29 | Dickson | Tennessee | 47043 | 4545 | 59 |
874304 | 874304 | 2020-12-28 | Dickson | Tennessee | 47043 | 4505 | 58 |
871059 | 871059 | 2020-12-27 | Dickson | Tennessee | 47043 | 4486 | 58 |
867814 | 867814 | 2020-12-26 | Dickson | Tennessee | 47043 | 4464 | 57 |
864569 | 864569 | 2020-12-25 | Dickson | Tennessee | 47043 | 4424 | 57 |
861324 | 861324 | 2020-12-24 | Dickson | Tennessee | 47043 | 4385 | 57 |
858079 | 858079 | 2020-12-23 | Dickson | Tennessee | 47043 | 4327 | 57 |
854834 | 854834 | 2020-12-22 | Dickson | Tennessee | 47043 | 4264 | 53 |
851589 | 851589 | 2020-12-21 | Dickson | Tennessee | 47043 | 4190 | 53 |
848344 | 848344 | 2020-12-20 | Dickson | Tennessee | 47043 | 4123 | 51 |
845099 | 845099 | 2020-12-19 | Dickson | Tennessee | 47043 | 4061 | 51 |
841853 | 841853 | 2020-12-18 | Dickson | Tennessee | 47043 | 4026 | 51 |
838608 | 838608 | 2020-12-17 | Dickson | Tennessee | 47043 | 3937 | 50 |
835362 | 835362 | 2020-12-16 | Dickson | Tennessee | 47043 | 3873 | 48 |
832116 | 832116 | 2020-12-15 | Dickson | Tennessee | 47043 | 3773 | 48 |
828869 | 828869 | 2020-12-14 | Dickson | Tennessee | 47043 | 3721 | 47 |
825623 | 825623 | 2020-12-13 | Dickson | Tennessee | 47043 | 3590 | 47 |
822376 | 822376 | 2020-12-12 | Dickson | Tennessee | 47043 | 3502 | 46 |
819130 | 819130 | 2020-12-11 | Dickson | Tennessee | 47043 | 3420 | 41 |
815884 | 815884 | 2020-12-10 | Dickson | Tennessee | 47043 | 3382 | 41 |
812638 | 812638 | 2020-12-09 | Dickson | Tennessee | 47043 | 3322 | 41 |
809394 | 809394 | 2020-12-08 | Dickson | Tennessee | 47043 | 3231 | 40 |
806149 | 806149 | 2020-12-07 | Dickson | Tennessee | 47043 | 3174 | 40 |
802904 | 802904 | 2020-12-06 | Dickson | Tennessee | 47043 | 3136 | 39 |
799659 | 799659 | 2020-12-05 | Dickson | Tennessee | 47043 | 3098 | 39 |
796414 | 796414 | 2020-12-04 | Dickson | Tennessee | 47043 | 3078 | 39 |
793169 | 793169 | 2020-12-03 | Dickson | Tennessee | 47043 | 3050 | 37 |
789924 | 789924 | 2020-12-02 | Dickson | Tennessee | 47043 | 3038 | 35 |
786679 | 786679 | 2020-12-01 | Dickson | Tennessee | 47043 | 3025 | 35 |
783435 | 783435 | 2020-11-30 | Dickson | Tennessee | 47043 | 3004 | 34 |
780190 | 780190 | 2020-11-29 | Dickson | Tennessee | 47043 | 2938 | 34 |
776944 | 776944 | 2020-11-28 | Dickson | Tennessee | 47043 | 2891 | 33 |
773699 | 773699 | 2020-11-27 | Dickson | Tennessee | 47043 | 2848 | 33 |
770454 | 770454 | 2020-11-26 | Dickson | Tennessee | 47043 | 2810 | 33 |
767208 | 767208 | 2020-11-25 | Dickson | Tennessee | 47043 | 2763 | 33 |
763963 | 763963 | 2020-11-24 | Dickson | Tennessee | 47043 | 2742 | 32 |
760718 | 760718 | 2020-11-23 | Dickson | Tennessee | 47043 | 2728 | 27 |
757473 | 757473 | 2020-11-22 | Dickson | Tennessee | 47043 | 2644 | 27 |
754226 | 754226 | 2020-11-21 | Dickson | Tennessee | 47043 | 2628 | 26 |
750980 | 750980 | 2020-11-20 | Dickson | Tennessee | 47043 | 2597 | 26 |
747734 | 747734 | 2020-11-19 | Dickson | Tennessee | 47043 | 2528 | 26 |
744488 | 744488 | 2020-11-18 | Dickson | Tennessee | 47043 | 2519 | 26 |
741241 | 741241 | 2020-11-17 | Dickson | Tennessee | 47043 | 2461 | 26 |
737995 | 737995 | 2020-11-16 | Dickson | Tennessee | 47043 | 2454 | 24 |
734751 | 734751 | 2020-11-15 | Dickson | Tennessee | 47043 | 2349 | 24 |
731505 | 731505 | 2020-11-14 | Dickson | Tennessee | 47043 | 2275 | 23 |
728261 | 728261 | 2020-11-13 | Dickson | Tennessee | 47043 | 2238 | 23 |
725017 | 725017 | 2020-11-12 | Dickson | Tennessee | 47043 | 2197 | 23 |
721774 | 721774 | 2020-11-11 | Dickson | Tennessee | 47043 | 2165 | 23 |
718531 | 718531 | 2020-11-10 | Dickson | Tennessee | 47043 | 2135 | 23 |
715288 | 715288 | 2020-11-09 | Dickson | Tennessee | 47043 | 2102 | 22 |
712044 | 712044 | 2020-11-08 | Dickson | Tennessee | 47043 | 2030 | 21 |
708800 | 708800 | 2020-11-07 | Dickson | Tennessee | 47043 | 2004 | 21 |
705557 | 705557 | 2020-11-06 | Dickson | Tennessee | 47043 | 1931 | 21 |
702314 | 702314 | 2020-11-05 | Dickson | Tennessee | 47043 | 1925 | 21 |
699070 | 699070 | 2020-11-04 | Dickson | Tennessee | 47043 | 1904 | 21 |
695827 | 695827 | 2020-11-03 | Dickson | Tennessee | 47043 | 1873 | 21 |
692585 | 692585 | 2020-11-02 | Dickson | Tennessee | 47043 | 1843 | 20 |
689341 | 689341 | 2020-11-01 | Dickson | Tennessee | 47043 | 1797 | 20 |
686096 | 686096 | 2020-10-31 | Dickson | Tennessee | 47043 | 1797 | 20 |
682853 | 682853 | 2020-10-30 | Dickson | Tennessee | 47043 | 1791 | 19 |
679610 | 679610 | 2020-10-29 | Dickson | Tennessee | 47043 | 1763 | 19 |
676367 | 676367 | 2020-10-28 | Dickson | Tennessee | 47043 | 1747 | 19 |
673124 | 673124 | 2020-10-27 | Dickson | Tennessee | 47043 | 1722 | 19 |
669882 | 669882 | 2020-10-26 | Dickson | Tennessee | 47043 | 1707 | 19 |
666638 | 666638 | 2020-10-25 | Dickson | Tennessee | 47043 | 1691 | 19 |
663393 | 663393 | 2020-10-24 | Dickson | Tennessee | 47043 | 1648 | 19 |
660149 | 660149 | 2020-10-23 | Dickson | Tennessee | 47043 | 1636 | 19 |
656905 | 656905 | 2020-10-22 | Dickson | Tennessee | 47043 | 1604 | 19 |
653660 | 653660 | 2020-10-21 | Dickson | Tennessee | 47043 | 1591 | 19 |
650415 | 650415 | 2020-10-20 | Dickson | Tennessee | 47043 | 1573 | 18 |
647171 | 647171 | 2020-10-19 | Dickson | Tennessee | 47043 | 1562 | 18 |
643925 | 643925 | 2020-10-18 | Dickson | Tennessee | 47043 | 1535 | 18 |
640677 | 640677 | 2020-10-17 | Dickson | Tennessee | 47043 | 1519 | 18 |
637431 | 637431 | 2020-10-16 | Dickson | Tennessee | 47043 | 1499 | 18 |
634185 | 634185 | 2020-10-15 | Dickson | Tennessee | 47043 | 1487 | 18 |
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);