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 |
---|---|---|---|---|---|---|---|
1195726 | 1195726 | 2021-04-06 | Washington | Tennessee | 47179 | 13695 | 239 |
1192478 | 1192478 | 2021-04-05 | Washington | Tennessee | 47179 | 13660 | 239 |
1189229 | 1189229 | 2021-04-04 | Washington | Tennessee | 47179 | 13533 | 239 |
1185982 | 1185982 | 2021-04-03 | Washington | Tennessee | 47179 | 13533 | 239 |
1182735 | 1182735 | 2021-04-02 | Washington | Tennessee | 47179 | 13533 | 239 |
1179488 | 1179488 | 2021-04-01 | Washington | Tennessee | 47179 | 13533 | 239 |
1176241 | 1176241 | 2021-03-31 | Washington | Tennessee | 47179 | 13482 | 239 |
1172994 | 1172994 | 2021-03-30 | Washington | Tennessee | 47179 | 13429 | 239 |
1169747 | 1169747 | 2021-03-29 | Washington | Tennessee | 47179 | 13412 | 238 |
1166499 | 1166499 | 2021-03-28 | Washington | Tennessee | 47179 | 13334 | 236 |
1163251 | 1163251 | 2021-03-27 | Washington | Tennessee | 47179 | 13334 | 236 |
1160002 | 1160002 | 2021-03-26 | Washington | Tennessee | 47179 | 13334 | 236 |
1156755 | 1156755 | 2021-03-25 | Washington | Tennessee | 47179 | 13292 | 236 |
1153508 | 1153508 | 2021-03-24 | Washington | Tennessee | 47179 | 13248 | 236 |
1150261 | 1150261 | 2021-03-23 | Washington | Tennessee | 47179 | 13209 | 236 |
1147014 | 1147014 | 2021-03-22 | Washington | Tennessee | 47179 | 13184 | 236 |
1143767 | 1143767 | 2021-03-21 | Washington | Tennessee | 47179 | 13112 | 235 |
1140520 | 1140520 | 2021-03-20 | Washington | Tennessee | 47179 | 13112 | 235 |
1137274 | 1137274 | 2021-03-19 | Washington | Tennessee | 47179 | 13112 | 235 |
1134028 | 1134028 | 2021-03-18 | Washington | Tennessee | 47179 | 13073 | 235 |
1130780 | 1130780 | 2021-03-17 | Washington | Tennessee | 47179 | 13047 | 235 |
1127533 | 1127533 | 2021-03-16 | Washington | Tennessee | 47179 | 13025 | 235 |
1124287 | 1124287 | 2021-03-15 | Washington | Tennessee | 47179 | 13004 | 234 |
1121041 | 1121041 | 2021-03-14 | Washington | Tennessee | 47179 | 12955 | 234 |
1117794 | 1117794 | 2021-03-13 | Washington | Tennessee | 47179 | 12955 | 234 |
1114547 | 1114547 | 2021-03-12 | Washington | Tennessee | 47179 | 12955 | 234 |
1111301 | 1111301 | 2021-03-11 | Washington | Tennessee | 47179 | 12925 | 234 |
1108055 | 1108055 | 2021-03-10 | Washington | Tennessee | 47179 | 12907 | 234 |
1104809 | 1104809 | 2021-03-09 | Washington | Tennessee | 47179 | 12890 | 234 |
1101563 | 1101563 | 2021-03-08 | Washington | Tennessee | 47179 | 12868 | 234 |
1098317 | 1098317 | 2021-03-07 | Washington | Tennessee | 47179 | 12856 | 234 |
1095069 | 1095069 | 2021-03-06 | Washington | Tennessee | 47179 | 12840 | 234 |
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 |
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);