ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
789 rows where fips = 47155 and state = "Tennessee" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
955494 | 955494 | 2021-01-22 | Sevier | Tennessee | 47155 | 10704 | 120 |
952249 | 952249 | 2021-01-21 | Sevier | Tennessee | 47155 | 10663 | 116 |
949004 | 949004 | 2021-01-20 | Sevier | Tennessee | 47155 | 10589 | 110 |
945758 | 945758 | 2021-01-19 | Sevier | Tennessee | 47155 | 10534 | 108 |
942511 | 942511 | 2021-01-18 | Sevier | Tennessee | 47155 | 10495 | 108 |
939266 | 939266 | 2021-01-17 | Sevier | Tennessee | 47155 | 10461 | 108 |
936021 | 936021 | 2021-01-16 | Sevier | Tennessee | 47155 | 10406 | 108 |
932776 | 932776 | 2021-01-15 | Sevier | Tennessee | 47155 | 10320 | 108 |
929531 | 929531 | 2021-01-14 | Sevier | Tennessee | 47155 | 10243 | 103 |
926286 | 926286 | 2021-01-13 | Sevier | Tennessee | 47155 | 10112 | 99 |
923040 | 923040 | 2021-01-12 | Sevier | Tennessee | 47155 | 10056 | 99 |
919795 | 919795 | 2021-01-11 | Sevier | Tennessee | 47155 | 10001 | 90 |
916550 | 916550 | 2021-01-10 | Sevier | Tennessee | 47155 | 9947 | 88 |
913305 | 913305 | 2021-01-09 | Sevier | Tennessee | 47155 | 9823 | 86 |
910060 | 910060 | 2021-01-08 | Sevier | Tennessee | 47155 | 9704 | 85 |
906815 | 906815 | 2021-01-07 | Sevier | Tennessee | 47155 | 9595 | 84 |
903569 | 903569 | 2021-01-06 | Sevier | Tennessee | 47155 | 9450 | 78 |
900324 | 900324 | 2021-01-05 | Sevier | Tennessee | 47155 | 9366 | 76 |
897079 | 897079 | 2021-01-04 | Sevier | Tennessee | 47155 | 9317 | 76 |
893833 | 893833 | 2021-01-03 | Sevier | Tennessee | 47155 | 9265 | 73 |
890587 | 890587 | 2021-01-02 | Sevier | Tennessee | 47155 | 9180 | 73 |
887340 | 887340 | 2021-01-01 | Sevier | Tennessee | 47155 | 8901 | 70 |
884095 | 884095 | 2020-12-31 | Sevier | Tennessee | 47155 | 8901 | 70 |
880850 | 880850 | 2020-12-30 | Sevier | Tennessee | 47155 | 8818 | 70 |
877605 | 877605 | 2020-12-29 | Sevier | Tennessee | 47155 | 8704 | 67 |
874360 | 874360 | 2020-12-28 | Sevier | Tennessee | 47155 | 8667 | 64 |
871115 | 871115 | 2020-12-27 | Sevier | Tennessee | 47155 | 8583 | 63 |
867870 | 867870 | 2020-12-26 | Sevier | Tennessee | 47155 | 8505 | 63 |
864625 | 864625 | 2020-12-25 | Sevier | Tennessee | 47155 | 8382 | 63 |
861380 | 861380 | 2020-12-24 | Sevier | Tennessee | 47155 | 8218 | 63 |
858135 | 858135 | 2020-12-23 | Sevier | Tennessee | 47155 | 8154 | 60 |
854890 | 854890 | 2020-12-22 | Sevier | Tennessee | 47155 | 8033 | 60 |
851645 | 851645 | 2020-12-21 | Sevier | Tennessee | 47155 | 7993 | 58 |
848400 | 848400 | 2020-12-20 | Sevier | Tennessee | 47155 | 7742 | 58 |
845155 | 845155 | 2020-12-19 | Sevier | Tennessee | 47155 | 7527 | 57 |
841909 | 841909 | 2020-12-18 | Sevier | Tennessee | 47155 | 7359 | 55 |
838664 | 838664 | 2020-12-17 | Sevier | Tennessee | 47155 | 7146 | 54 |
835418 | 835418 | 2020-12-16 | Sevier | Tennessee | 47155 | 6993 | 54 |
832172 | 832172 | 2020-12-15 | Sevier | Tennessee | 47155 | 6770 | 54 |
828925 | 828925 | 2020-12-14 | Sevier | Tennessee | 47155 | 6594 | 50 |
825679 | 825679 | 2020-12-13 | Sevier | Tennessee | 47155 | 6453 | 47 |
822432 | 822432 | 2020-12-12 | Sevier | Tennessee | 47155 | 6206 | 46 |
819186 | 819186 | 2020-12-11 | Sevier | Tennessee | 47155 | 6126 | 44 |
815940 | 815940 | 2020-12-10 | Sevier | Tennessee | 47155 | 5964 | 42 |
812694 | 812694 | 2020-12-09 | Sevier | Tennessee | 47155 | 5862 | 41 |
809450 | 809450 | 2020-12-08 | Sevier | Tennessee | 47155 | 5646 | 41 |
806205 | 806205 | 2020-12-07 | Sevier | Tennessee | 47155 | 5579 | 40 |
802960 | 802960 | 2020-12-06 | Sevier | Tennessee | 47155 | 5409 | 39 |
799715 | 799715 | 2020-12-05 | Sevier | Tennessee | 47155 | 5384 | 39 |
796470 | 796470 | 2020-12-04 | Sevier | Tennessee | 47155 | 5317 | 38 |
793225 | 793225 | 2020-12-03 | Sevier | Tennessee | 47155 | 5287 | 35 |
789980 | 789980 | 2020-12-02 | Sevier | Tennessee | 47155 | 5238 | 33 |
786735 | 786735 | 2020-12-01 | Sevier | Tennessee | 47155 | 5219 | 33 |
783491 | 783491 | 2020-11-30 | Sevier | Tennessee | 47155 | 5121 | 33 |
780246 | 780246 | 2020-11-29 | Sevier | Tennessee | 47155 | 4937 | 31 |
777000 | 777000 | 2020-11-28 | Sevier | Tennessee | 47155 | 4848 | 31 |
773755 | 773755 | 2020-11-27 | Sevier | Tennessee | 47155 | 4768 | 31 |
770510 | 770510 | 2020-11-26 | Sevier | Tennessee | 47155 | 4738 | 31 |
767264 | 767264 | 2020-11-25 | Sevier | Tennessee | 47155 | 4712 | 31 |
764019 | 764019 | 2020-11-24 | Sevier | Tennessee | 47155 | 4691 | 31 |
760774 | 760774 | 2020-11-23 | Sevier | Tennessee | 47155 | 4681 | 31 |
757529 | 757529 | 2020-11-22 | Sevier | Tennessee | 47155 | 4585 | 30 |
754282 | 754282 | 2020-11-21 | Sevier | Tennessee | 47155 | 4495 | 29 |
751036 | 751036 | 2020-11-20 | Sevier | Tennessee | 47155 | 4419 | 29 |
747790 | 747790 | 2020-11-19 | Sevier | Tennessee | 47155 | 4346 | 28 |
744544 | 744544 | 2020-11-18 | Sevier | Tennessee | 47155 | 4337 | 27 |
741297 | 741297 | 2020-11-17 | Sevier | Tennessee | 47155 | 4250 | 27 |
738051 | 738051 | 2020-11-16 | Sevier | Tennessee | 47155 | 4225 | 27 |
734807 | 734807 | 2020-11-15 | Sevier | Tennessee | 47155 | 4126 | 27 |
731561 | 731561 | 2020-11-14 | Sevier | Tennessee | 47155 | 4082 | 27 |
728317 | 728317 | 2020-11-13 | Sevier | Tennessee | 47155 | 4029 | 27 |
725073 | 725073 | 2020-11-12 | Sevier | Tennessee | 47155 | 3948 | 27 |
721830 | 721830 | 2020-11-11 | Sevier | Tennessee | 47155 | 3920 | 26 |
718587 | 718587 | 2020-11-10 | Sevier | Tennessee | 47155 | 3883 | 26 |
715344 | 715344 | 2020-11-09 | Sevier | Tennessee | 47155 | 3868 | 26 |
712100 | 712100 | 2020-11-08 | Sevier | Tennessee | 47155 | 3814 | 26 |
708856 | 708856 | 2020-11-07 | Sevier | Tennessee | 47155 | 3757 | 26 |
705613 | 705613 | 2020-11-06 | Sevier | Tennessee | 47155 | 3690 | 24 |
702370 | 702370 | 2020-11-05 | Sevier | Tennessee | 47155 | 3662 | 24 |
699126 | 699126 | 2020-11-04 | Sevier | Tennessee | 47155 | 3637 | 24 |
695883 | 695883 | 2020-11-03 | Sevier | Tennessee | 47155 | 3601 | 24 |
692641 | 692641 | 2020-11-02 | Sevier | Tennessee | 47155 | 3580 | 23 |
689397 | 689397 | 2020-11-01 | Sevier | Tennessee | 47155 | 3548 | 23 |
686152 | 686152 | 2020-10-31 | Sevier | Tennessee | 47155 | 3547 | 23 |
682909 | 682909 | 2020-10-30 | Sevier | Tennessee | 47155 | 3534 | 23 |
679666 | 679666 | 2020-10-29 | Sevier | Tennessee | 47155 | 3497 | 22 |
676423 | 676423 | 2020-10-28 | Sevier | Tennessee | 47155 | 3461 | 22 |
673180 | 673180 | 2020-10-27 | Sevier | Tennessee | 47155 | 3408 | 23 |
669938 | 669938 | 2020-10-26 | Sevier | Tennessee | 47155 | 3364 | 23 |
666694 | 666694 | 2020-10-25 | Sevier | Tennessee | 47155 | 3351 | 22 |
663449 | 663449 | 2020-10-24 | Sevier | Tennessee | 47155 | 3328 | 21 |
660205 | 660205 | 2020-10-23 | Sevier | Tennessee | 47155 | 3299 | 21 |
656961 | 656961 | 2020-10-22 | Sevier | Tennessee | 47155 | 3241 | 21 |
653716 | 653716 | 2020-10-21 | Sevier | Tennessee | 47155 | 3224 | 21 |
650471 | 650471 | 2020-10-20 | Sevier | Tennessee | 47155 | 3173 | 21 |
647227 | 647227 | 2020-10-19 | Sevier | Tennessee | 47155 | 3149 | 20 |
643981 | 643981 | 2020-10-18 | Sevier | Tennessee | 47155 | 3124 | 20 |
640733 | 640733 | 2020-10-17 | Sevier | Tennessee | 47155 | 3109 | 20 |
637487 | 637487 | 2020-10-16 | Sevier | Tennessee | 47155 | 3054 | 20 |
634241 | 634241 | 2020-10-15 | Sevier | Tennessee | 47155 | 3044 | 20 |
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);