ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
786 rows where county = "Washington" and state = "Tennessee" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1091823 | 1091823 | 2021-03-05 | Washington | Tennessee | 47179 | 12834 | 234 |
1088577 | 1088577 | 2021-03-04 | Washington | Tennessee | 47179 | 12818 | 234 |
1085332 | 1085332 | 2021-03-03 | Washington | Tennessee | 47179 | 12792 | 234 |
1082086 | 1082086 | 2021-03-02 | Washington | Tennessee | 47179 | 12774 | 234 |
1078840 | 1078840 | 2021-03-01 | Washington | Tennessee | 47179 | 12771 | 234 |
1075595 | 1075595 | 2021-02-28 | Washington | Tennessee | 47179 | 12759 | 234 |
1072349 | 1072349 | 2021-02-27 | Washington | Tennessee | 47179 | 12740 | 234 |
1069103 | 1069103 | 2021-02-26 | Washington | Tennessee | 47179 | 12723 | 234 |
1065858 | 1065858 | 2021-02-25 | Washington | Tennessee | 47179 | 12693 | 232 |
1062613 | 1062613 | 2021-02-24 | Washington | Tennessee | 47179 | 12671 | 231 |
1059368 | 1059368 | 2021-02-23 | Washington | Tennessee | 47179 | 12659 | 231 |
1056122 | 1056122 | 2021-02-22 | Washington | Tennessee | 47179 | 12641 | 230 |
1052876 | 1052876 | 2021-02-21 | Washington | Tennessee | 47179 | 12637 | 230 |
1049629 | 1049629 | 2021-02-20 | Washington | Tennessee | 47179 | 12620 | 230 |
1046382 | 1046382 | 2021-02-19 | Washington | Tennessee | 47179 | 12598 | 227 |
1043137 | 1043137 | 2021-02-18 | Washington | Tennessee | 47179 | 12586 | 227 |
1039892 | 1039892 | 2021-02-17 | Washington | Tennessee | 47179 | 12560 | 225 |
1036647 | 1036647 | 2021-02-16 | Washington | Tennessee | 47179 | 12534 | 225 |
1033402 | 1033402 | 2021-02-15 | Washington | Tennessee | 47179 | 12523 | 225 |
1030156 | 1030156 | 2021-02-14 | Washington | Tennessee | 47179 | 12513 | 224 |
1026909 | 1026909 | 2021-02-13 | Washington | Tennessee | 47179 | 12505 | 223 |
1023664 | 1023664 | 2021-02-12 | Washington | Tennessee | 47179 | 12472 | 222 |
1020419 | 1020419 | 2021-02-11 | Washington | Tennessee | 47179 | 12439 | 221 |
1017174 | 1017174 | 2021-02-10 | Washington | Tennessee | 47179 | 12428 | 222 |
1013929 | 1013929 | 2021-02-09 | Washington | Tennessee | 47179 | 12565 | 224 |
1010684 | 1010684 | 2021-02-08 | Washington | Tennessee | 47179 | 12597 | 225 |
1007438 | 1007438 | 2021-02-07 | Washington | Tennessee | 47179 | 12583 | 222 |
1004192 | 1004192 | 2021-02-06 | Washington | Tennessee | 47179 | 12561 | 222 |
1000946 | 1000946 | 2021-02-05 | Washington | Tennessee | 47179 | 12535 | 222 |
997700 | 997700 | 2021-02-04 | Washington | Tennessee | 47179 | 12517 | 221 |
994454 | 994454 | 2021-02-03 | Washington | Tennessee | 47179 | 12483 | 221 |
991208 | 991208 | 2021-02-02 | Washington | Tennessee | 47179 | 12456 | 220 |
987962 | 987962 | 2021-02-01 | Washington | Tennessee | 47179 | 12437 | 219 |
984715 | 984715 | 2021-01-31 | Washington | Tennessee | 47179 | 12430 | 219 |
981468 | 981468 | 2021-01-30 | Washington | Tennessee | 47179 | 12401 | 214 |
978222 | 978222 | 2021-01-29 | Washington | Tennessee | 47179 | 12366 | 213 |
974977 | 974977 | 2021-01-28 | Washington | Tennessee | 47179 | 12299 | 213 |
971732 | 971732 | 2021-01-27 | Washington | Tennessee | 47179 | 12283 | 211 |
968487 | 968487 | 2021-01-26 | Washington | Tennessee | 47179 | 12236 | 209 |
965243 | 965243 | 2021-01-25 | Washington | Tennessee | 47179 | 12206 | 206 |
961998 | 961998 | 2021-01-24 | Washington | Tennessee | 47179 | 12184 | 205 |
958753 | 958753 | 2021-01-23 | Washington | Tennessee | 47179 | 12148 | 204 |
955507 | 955507 | 2021-01-22 | Washington | Tennessee | 47179 | 12102 | 203 |
952262 | 952262 | 2021-01-21 | Washington | Tennessee | 47179 | 12055 | 199 |
949017 | 949017 | 2021-01-20 | Washington | Tennessee | 47179 | 12010 | 193 |
945771 | 945771 | 2021-01-19 | Washington | Tennessee | 47179 | 11949 | 192 |
942524 | 942524 | 2021-01-18 | Washington | Tennessee | 47179 | 11911 | 191 |
939279 | 939279 | 2021-01-17 | Washington | Tennessee | 47179 | 11889 | 191 |
936034 | 936034 | 2021-01-16 | Washington | Tennessee | 47179 | 11818 | 191 |
932789 | 932789 | 2021-01-15 | Washington | Tennessee | 47179 | 11757 | 191 |
929544 | 929544 | 2021-01-14 | Washington | Tennessee | 47179 | 11674 | 191 |
926299 | 926299 | 2021-01-13 | Washington | Tennessee | 47179 | 11603 | 189 |
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 |
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);