ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
795 rows where fips = 47163 and state = "Tennessee" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
955498 | 955498 | 2021-01-22 | Sullivan | Tennessee | 47163 | 12893 | 218 |
952253 | 952253 | 2021-01-21 | Sullivan | Tennessee | 47163 | 12811 | 216 |
949008 | 949008 | 2021-01-20 | Sullivan | Tennessee | 47163 | 12736 | 212 |
945762 | 945762 | 2021-01-19 | Sullivan | Tennessee | 47163 | 12634 | 211 |
942515 | 942515 | 2021-01-18 | Sullivan | Tennessee | 47163 | 12606 | 211 |
939270 | 939270 | 2021-01-17 | Sullivan | Tennessee | 47163 | 12577 | 211 |
936025 | 936025 | 2021-01-16 | Sullivan | Tennessee | 47163 | 12473 | 210 |
932780 | 932780 | 2021-01-15 | Sullivan | Tennessee | 47163 | 12405 | 209 |
929535 | 929535 | 2021-01-14 | Sullivan | Tennessee | 47163 | 12293 | 207 |
926290 | 926290 | 2021-01-13 | Sullivan | Tennessee | 47163 | 12209 | 206 |
923044 | 923044 | 2021-01-12 | Sullivan | Tennessee | 47163 | 12133 | 203 |
919799 | 919799 | 2021-01-11 | Sullivan | Tennessee | 47163 | 12071 | 202 |
916554 | 916554 | 2021-01-10 | Sullivan | Tennessee | 47163 | 12010 | 200 |
913309 | 913309 | 2021-01-09 | Sullivan | Tennessee | 47163 | 11937 | 198 |
910064 | 910064 | 2021-01-08 | Sullivan | Tennessee | 47163 | 11801 | 198 |
906819 | 906819 | 2021-01-07 | Sullivan | Tennessee | 47163 | 11662 | 196 |
903573 | 903573 | 2021-01-06 | Sullivan | Tennessee | 47163 | 11528 | 196 |
900328 | 900328 | 2021-01-05 | Sullivan | Tennessee | 47163 | 11377 | 192 |
897083 | 897083 | 2021-01-04 | Sullivan | Tennessee | 47163 | 11276 | 188 |
893837 | 893837 | 2021-01-03 | Sullivan | Tennessee | 47163 | 11203 | 181 |
890591 | 890591 | 2021-01-02 | Sullivan | Tennessee | 47163 | 11106 | 181 |
887344 | 887344 | 2021-01-01 | Sullivan | Tennessee | 47163 | 10862 | 178 |
884099 | 884099 | 2020-12-31 | Sullivan | Tennessee | 47163 | 10862 | 178 |
880854 | 880854 | 2020-12-30 | Sullivan | Tennessee | 47163 | 10739 | 177 |
877609 | 877609 | 2020-12-29 | Sullivan | Tennessee | 47163 | 10545 | 175 |
874364 | 874364 | 2020-12-28 | Sullivan | Tennessee | 47163 | 10443 | 172 |
871119 | 871119 | 2020-12-27 | Sullivan | Tennessee | 47163 | 10424 | 170 |
867874 | 867874 | 2020-12-26 | Sullivan | Tennessee | 47163 | 10374 | 167 |
864629 | 864629 | 2020-12-25 | Sullivan | Tennessee | 47163 | 10233 | 167 |
861384 | 861384 | 2020-12-24 | Sullivan | Tennessee | 47163 | 10151 | 167 |
858139 | 858139 | 2020-12-23 | Sullivan | Tennessee | 47163 | 10040 | 166 |
854894 | 854894 | 2020-12-22 | Sullivan | Tennessee | 47163 | 9877 | 164 |
851649 | 851649 | 2020-12-21 | Sullivan | Tennessee | 47163 | 9842 | 161 |
848404 | 848404 | 2020-12-20 | Sullivan | Tennessee | 47163 | 9680 | 161 |
845159 | 845159 | 2020-12-19 | Sullivan | Tennessee | 47163 | 9435 | 161 |
841913 | 841913 | 2020-12-18 | Sullivan | Tennessee | 47163 | 9315 | 158 |
838668 | 838668 | 2020-12-17 | Sullivan | Tennessee | 47163 | 9080 | 154 |
835422 | 835422 | 2020-12-16 | Sullivan | Tennessee | 47163 | 8949 | 150 |
832176 | 832176 | 2020-12-15 | Sullivan | Tennessee | 47163 | 8745 | 149 |
828929 | 828929 | 2020-12-14 | Sullivan | Tennessee | 47163 | 8603 | 141 |
825683 | 825683 | 2020-12-13 | Sullivan | Tennessee | 47163 | 8358 | 135 |
822436 | 822436 | 2020-12-12 | Sullivan | Tennessee | 47163 | 8119 | 131 |
819190 | 819190 | 2020-12-11 | Sullivan | Tennessee | 47163 | 7997 | 128 |
815944 | 815944 | 2020-12-10 | Sullivan | Tennessee | 47163 | 7888 | 126 |
812698 | 812698 | 2020-12-09 | Sullivan | Tennessee | 47163 | 7730 | 125 |
809454 | 809454 | 2020-12-08 | Sullivan | Tennessee | 47163 | 7587 | 125 |
806209 | 806209 | 2020-12-07 | Sullivan | Tennessee | 47163 | 7459 | 120 |
802964 | 802964 | 2020-12-06 | Sullivan | Tennessee | 47163 | 7279 | 117 |
799719 | 799719 | 2020-12-05 | Sullivan | Tennessee | 47163 | 7249 | 116 |
796474 | 796474 | 2020-12-04 | Sullivan | Tennessee | 47163 | 7128 | 114 |
793229 | 793229 | 2020-12-03 | Sullivan | Tennessee | 47163 | 6979 | 111 |
789984 | 789984 | 2020-12-02 | Sullivan | Tennessee | 47163 | 6913 | 105 |
786739 | 786739 | 2020-12-01 | Sullivan | Tennessee | 47163 | 6787 | 102 |
783495 | 783495 | 2020-11-30 | Sullivan | Tennessee | 47163 | 6641 | 101 |
780250 | 780250 | 2020-11-29 | Sullivan | Tennessee | 47163 | 6485 | 97 |
777004 | 777004 | 2020-11-28 | Sullivan | Tennessee | 47163 | 6439 | 96 |
773759 | 773759 | 2020-11-27 | Sullivan | Tennessee | 47163 | 6300 | 96 |
770514 | 770514 | 2020-11-26 | Sullivan | Tennessee | 47163 | 6249 | 96 |
767268 | 767268 | 2020-11-25 | Sullivan | Tennessee | 47163 | 6188 | 96 |
764023 | 764023 | 2020-11-24 | Sullivan | Tennessee | 47163 | 6124 | 91 |
760778 | 760778 | 2020-11-23 | Sullivan | Tennessee | 47163 | 6093 | 89 |
757533 | 757533 | 2020-11-22 | Sullivan | Tennessee | 47163 | 5946 | 89 |
754286 | 754286 | 2020-11-21 | Sullivan | Tennessee | 47163 | 5855 | 89 |
751040 | 751040 | 2020-11-20 | Sullivan | Tennessee | 47163 | 5755 | 89 |
747794 | 747794 | 2020-11-19 | Sullivan | Tennessee | 47163 | 5620 | 89 |
744548 | 744548 | 2020-11-18 | Sullivan | Tennessee | 47163 | 5504 | 79 |
741301 | 741301 | 2020-11-17 | Sullivan | Tennessee | 47163 | 5394 | 77 |
738055 | 738055 | 2020-11-16 | Sullivan | Tennessee | 47163 | 5382 | 77 |
734811 | 734811 | 2020-11-15 | Sullivan | Tennessee | 47163 | 5253 | 77 |
731565 | 731565 | 2020-11-14 | Sullivan | Tennessee | 47163 | 5059 | 77 |
728321 | 728321 | 2020-11-13 | Sullivan | Tennessee | 47163 | 4982 | 75 |
725077 | 725077 | 2020-11-12 | Sullivan | Tennessee | 47163 | 4878 | 74 |
721834 | 721834 | 2020-11-11 | Sullivan | Tennessee | 47163 | 4802 | 74 |
718591 | 718591 | 2020-11-10 | Sullivan | Tennessee | 47163 | 4761 | 71 |
715348 | 715348 | 2020-11-09 | Sullivan | Tennessee | 47163 | 4735 | 65 |
712104 | 712104 | 2020-11-08 | Sullivan | Tennessee | 47163 | 4607 | 64 |
708860 | 708860 | 2020-11-07 | Sullivan | Tennessee | 47163 | 4519 | 64 |
705617 | 705617 | 2020-11-06 | Sullivan | Tennessee | 47163 | 4409 | 61 |
702374 | 702374 | 2020-11-05 | Sullivan | Tennessee | 47163 | 4365 | 61 |
699130 | 699130 | 2020-11-04 | Sullivan | Tennessee | 47163 | 4330 | 58 |
695887 | 695887 | 2020-11-03 | Sullivan | Tennessee | 47163 | 4242 | 58 |
692645 | 692645 | 2020-11-02 | Sullivan | Tennessee | 47163 | 4167 | 55 |
689401 | 689401 | 2020-11-01 | Sullivan | Tennessee | 47163 | 4144 | 53 |
686156 | 686156 | 2020-10-31 | Sullivan | Tennessee | 47163 | 4142 | 53 |
682913 | 682913 | 2020-10-30 | Sullivan | Tennessee | 47163 | 4100 | 52 |
679670 | 679670 | 2020-10-29 | Sullivan | Tennessee | 47163 | 3981 | 50 |
676427 | 676427 | 2020-10-28 | Sullivan | Tennessee | 47163 | 3923 | 49 |
673184 | 673184 | 2020-10-27 | Sullivan | Tennessee | 47163 | 3846 | 48 |
669942 | 669942 | 2020-10-26 | Sullivan | Tennessee | 47163 | 3819 | 46 |
666698 | 666698 | 2020-10-25 | Sullivan | Tennessee | 47163 | 3763 | 46 |
663453 | 663453 | 2020-10-24 | Sullivan | Tennessee | 47163 | 3653 | 46 |
660209 | 660209 | 2020-10-23 | Sullivan | Tennessee | 47163 | 3540 | 46 |
656965 | 656965 | 2020-10-22 | Sullivan | Tennessee | 47163 | 3395 | 46 |
653720 | 653720 | 2020-10-21 | Sullivan | Tennessee | 47163 | 3321 | 46 |
650475 | 650475 | 2020-10-20 | Sullivan | Tennessee | 47163 | 3248 | 45 |
647231 | 647231 | 2020-10-19 | Sullivan | Tennessee | 47163 | 3188 | 44 |
643985 | 643985 | 2020-10-18 | Sullivan | Tennessee | 47163 | 3103 | 44 |
640737 | 640737 | 2020-10-17 | Sullivan | Tennessee | 47163 | 3072 | 44 |
637491 | 637491 | 2020-10-16 | Sullivan | Tennessee | 47163 | 2943 | 42 |
634245 | 634245 | 2020-10-15 | Sullivan | Tennessee | 47163 | 2914 | 42 |
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);