ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
786 rows where county = "Washington" and fips = 47179 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
923053 | 923053 | 2021-01-12 | Washington | Tennessee | 47179 | 11534 | 188 |
919808 | 919808 | 2021-01-11 | Washington | Tennessee | 47179 | 11482 | 187 |
916563 | 916563 | 2021-01-10 | Washington | Tennessee | 47179 | 11414 | 186 |
913318 | 913318 | 2021-01-09 | Washington | Tennessee | 47179 | 11318 | 185 |
910073 | 910073 | 2021-01-08 | Washington | Tennessee | 47179 | 11240 | 182 |
906828 | 906828 | 2021-01-07 | Washington | Tennessee | 47179 | 11056 | 179 |
903582 | 903582 | 2021-01-06 | Washington | Tennessee | 47179 | 10970 | 179 |
900337 | 900337 | 2021-01-05 | Washington | Tennessee | 47179 | 10849 | 172 |
897092 | 897092 | 2021-01-04 | Washington | Tennessee | 47179 | 10743 | 169 |
893846 | 893846 | 2021-01-03 | Washington | Tennessee | 47179 | 10672 | 165 |
890600 | 890600 | 2021-01-02 | Washington | Tennessee | 47179 | 10542 | 165 |
887353 | 887353 | 2021-01-01 | Washington | Tennessee | 47179 | 10223 | 165 |
884108 | 884108 | 2020-12-31 | Washington | Tennessee | 47179 | 10223 | 165 |
880863 | 880863 | 2020-12-30 | Washington | Tennessee | 47179 | 10131 | 164 |
877618 | 877618 | 2020-12-29 | Washington | Tennessee | 47179 | 10026 | 162 |
874373 | 874373 | 2020-12-28 | Washington | Tennessee | 47179 | 9908 | 157 |
871128 | 871128 | 2020-12-27 | Washington | Tennessee | 47179 | 9849 | 155 |
867883 | 867883 | 2020-12-26 | Washington | Tennessee | 47179 | 9769 | 153 |
864638 | 864638 | 2020-12-25 | Washington | Tennessee | 47179 | 9651 | 153 |
861393 | 861393 | 2020-12-24 | Washington | Tennessee | 47179 | 9562 | 153 |
858148 | 858148 | 2020-12-23 | Washington | Tennessee | 47179 | 9499 | 153 |
854903 | 854903 | 2020-12-22 | Washington | Tennessee | 47179 | 9345 | 151 |
851658 | 851658 | 2020-12-21 | Washington | Tennessee | 47179 | 9266 | 144 |
848413 | 848413 | 2020-12-20 | Washington | Tennessee | 47179 | 9134 | 144 |
845168 | 845168 | 2020-12-19 | Washington | Tennessee | 47179 | 8958 | 144 |
841922 | 841922 | 2020-12-18 | Washington | Tennessee | 47179 | 8796 | 143 |
838677 | 838677 | 2020-12-17 | Washington | Tennessee | 47179 | 8632 | 135 |
835431 | 835431 | 2020-12-16 | Washington | Tennessee | 47179 | 8460 | 135 |
832185 | 832185 | 2020-12-15 | Washington | Tennessee | 47179 | 8295 | 134 |
828938 | 828938 | 2020-12-14 | Washington | Tennessee | 47179 | 8101 | 129 |
825692 | 825692 | 2020-12-13 | Washington | Tennessee | 47179 | 7921 | 129 |
822445 | 822445 | 2020-12-12 | Washington | Tennessee | 47179 | 7677 | 129 |
819199 | 819199 | 2020-12-11 | Washington | Tennessee | 47179 | 7577 | 129 |
815953 | 815953 | 2020-12-10 | Washington | Tennessee | 47179 | 7457 | 128 |
812707 | 812707 | 2020-12-09 | Washington | Tennessee | 47179 | 7327 | 128 |
809463 | 809463 | 2020-12-08 | Washington | Tennessee | 47179 | 7104 | 124 |
806218 | 806218 | 2020-12-07 | Washington | Tennessee | 47179 | 7012 | 120 |
802973 | 802973 | 2020-12-06 | Washington | Tennessee | 47179 | 6820 | 120 |
799728 | 799728 | 2020-12-05 | Washington | Tennessee | 47179 | 6772 | 118 |
796483 | 796483 | 2020-12-04 | Washington | Tennessee | 47179 | 6651 | 118 |
793238 | 793238 | 2020-12-03 | Washington | Tennessee | 47179 | 6572 | 116 |
789993 | 789993 | 2020-12-02 | Washington | Tennessee | 47179 | 6469 | 114 |
786748 | 786748 | 2020-12-01 | Washington | Tennessee | 47179 | 6360 | 109 |
783504 | 783504 | 2020-11-30 | Washington | Tennessee | 47179 | 6272 | 108 |
780259 | 780259 | 2020-11-29 | Washington | Tennessee | 47179 | 6073 | 106 |
777013 | 777013 | 2020-11-28 | Washington | Tennessee | 47179 | 6000 | 106 |
773768 | 773768 | 2020-11-27 | Washington | Tennessee | 47179 | 5844 | 106 |
770523 | 770523 | 2020-11-26 | Washington | Tennessee | 47179 | 5751 | 106 |
767277 | 767277 | 2020-11-25 | Washington | Tennessee | 47179 | 5667 | 102 |
764032 | 764032 | 2020-11-24 | Washington | Tennessee | 47179 | 5609 | 101 |
760787 | 760787 | 2020-11-23 | Washington | Tennessee | 47179 | 5596 | 100 |
757542 | 757542 | 2020-11-22 | Washington | Tennessee | 47179 | 5502 | 98 |
754295 | 754295 | 2020-11-21 | Washington | Tennessee | 47179 | 5415 | 96 |
751049 | 751049 | 2020-11-20 | Washington | Tennessee | 47179 | 5338 | 95 |
747803 | 747803 | 2020-11-19 | Washington | Tennessee | 47179 | 5277 | 92 |
744557 | 744557 | 2020-11-18 | Washington | Tennessee | 47179 | 5197 | 89 |
741310 | 741310 | 2020-11-17 | Washington | Tennessee | 47179 | 5125 | 88 |
738064 | 738064 | 2020-11-16 | Washington | Tennessee | 47179 | 5077 | 87 |
734820 | 734820 | 2020-11-15 | Washington | Tennessee | 47179 | 4930 | 87 |
731574 | 731574 | 2020-11-14 | Washington | Tennessee | 47179 | 4811 | 85 |
728329 | 728329 | 2020-11-13 | Washington | Tennessee | 47179 | 4720 | 85 |
725086 | 725086 | 2020-11-12 | Washington | Tennessee | 47179 | 4701 | 84 |
721843 | 721843 | 2020-11-11 | Washington | Tennessee | 47179 | 4635 | 83 |
718600 | 718600 | 2020-11-10 | Washington | Tennessee | 47179 | 4553 | 83 |
715357 | 715357 | 2020-11-09 | Washington | Tennessee | 47179 | 4525 | 78 |
712113 | 712113 | 2020-11-08 | Washington | Tennessee | 47179 | 4395 | 78 |
708869 | 708869 | 2020-11-07 | Washington | Tennessee | 47179 | 4338 | 78 |
705625 | 705625 | 2020-11-06 | Washington | Tennessee | 47179 | 4282 | 75 |
702382 | 702382 | 2020-11-05 | Washington | Tennessee | 47179 | 4268 | 72 |
699139 | 699139 | 2020-11-04 | Washington | Tennessee | 47179 | 4205 | 67 |
695895 | 695895 | 2020-11-03 | Washington | Tennessee | 47179 | 4069 | 67 |
692653 | 692653 | 2020-11-02 | Washington | Tennessee | 47179 | 3967 | 60 |
689409 | 689409 | 2020-11-01 | Washington | Tennessee | 47179 | 3948 | 59 |
686164 | 686164 | 2020-10-31 | Washington | Tennessee | 47179 | 3940 | 59 |
682921 | 682921 | 2020-10-30 | Washington | Tennessee | 47179 | 3877 | 58 |
679678 | 679678 | 2020-10-29 | Washington | Tennessee | 47179 | 3767 | 53 |
676435 | 676435 | 2020-10-28 | Washington | Tennessee | 47179 | 3663 | 53 |
673192 | 673192 | 2020-10-27 | Washington | Tennessee | 47179 | 3615 | 53 |
669950 | 669950 | 2020-10-26 | Washington | Tennessee | 47179 | 3569 | 51 |
666707 | 666707 | 2020-10-25 | Washington | Tennessee | 47179 | 3476 | 51 |
663462 | 663462 | 2020-10-24 | Washington | Tennessee | 47179 | 3388 | 50 |
660218 | 660218 | 2020-10-23 | Washington | Tennessee | 47179 | 3326 | 49 |
656974 | 656974 | 2020-10-22 | Washington | Tennessee | 47179 | 3241 | 46 |
653729 | 653729 | 2020-10-21 | Washington | Tennessee | 47179 | 3182 | 44 |
650484 | 650484 | 2020-10-20 | Washington | Tennessee | 47179 | 3132 | 44 |
647240 | 647240 | 2020-10-19 | Washington | Tennessee | 47179 | 3080 | 43 |
643994 | 643994 | 2020-10-18 | Washington | Tennessee | 47179 | 2991 | 43 |
640746 | 640746 | 2020-10-17 | Washington | Tennessee | 47179 | 2933 | 42 |
637499 | 637499 | 2020-10-16 | Washington | Tennessee | 47179 | 2874 | 42 |
634254 | 634254 | 2020-10-15 | Washington | Tennessee | 47179 | 2855 | 42 |
631009 | 631009 | 2020-10-14 | Washington | Tennessee | 47179 | 2801 | 42 |
627765 | 627765 | 2020-10-13 | Washington | Tennessee | 47179 | 2783 | 42 |
624523 | 624523 | 2020-10-12 | Washington | Tennessee | 47179 | 2761 | 41 |
621280 | 621280 | 2020-10-11 | Washington | Tennessee | 47179 | 2709 | 40 |
618037 | 618037 | 2020-10-10 | Washington | Tennessee | 47179 | 2672 | 40 |
614795 | 614795 | 2020-10-09 | Washington | Tennessee | 47179 | 2623 | 39 |
611554 | 611554 | 2020-10-08 | Washington | Tennessee | 47179 | 2590 | 39 |
608312 | 608312 | 2020-10-07 | Washington | Tennessee | 47179 | 2573 | 38 |
605069 | 605069 | 2020-10-06 | Washington | Tennessee | 47179 | 2531 | 38 |
601827 | 601827 | 2020-10-05 | Washington | Tennessee | 47179 | 2512 | 38 |
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);