ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
785 rows where fips = 47043 and state = "Tennessee" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1195657 | 1195657 | 2021-04-06 | Dickson | Tennessee | 47043 | 6596 | 108 |
1192409 | 1192409 | 2021-04-05 | Dickson | Tennessee | 47043 | 6578 | 107 |
1189160 | 1189160 | 2021-04-04 | Dickson | Tennessee | 47043 | 6526 | 107 |
1185913 | 1185913 | 2021-04-03 | Dickson | Tennessee | 47043 | 6526 | 107 |
1182666 | 1182666 | 2021-04-02 | Dickson | Tennessee | 47043 | 6526 | 107 |
1179419 | 1179419 | 2021-04-01 | Dickson | Tennessee | 47043 | 6526 | 107 |
1176172 | 1176172 | 2021-03-31 | Dickson | Tennessee | 47043 | 6506 | 107 |
1172925 | 1172925 | 2021-03-30 | Dickson | Tennessee | 47043 | 6500 | 107 |
1169678 | 1169678 | 2021-03-29 | Dickson | Tennessee | 47043 | 6491 | 107 |
1166430 | 1166430 | 2021-03-28 | Dickson | Tennessee | 47043 | 6471 | 107 |
1163182 | 1163182 | 2021-03-27 | Dickson | Tennessee | 47043 | 6471 | 107 |
1159933 | 1159933 | 2021-03-26 | Dickson | Tennessee | 47043 | 6471 | 107 |
1156686 | 1156686 | 2021-03-25 | Dickson | Tennessee | 47043 | 6467 | 107 |
1153439 | 1153439 | 2021-03-24 | Dickson | Tennessee | 47043 | 6456 | 107 |
1150192 | 1150192 | 2021-03-23 | Dickson | Tennessee | 47043 | 6443 | 107 |
1146945 | 1146945 | 2021-03-22 | Dickson | Tennessee | 47043 | 6434 | 107 |
1143698 | 1143698 | 2021-03-21 | Dickson | Tennessee | 47043 | 6407 | 107 |
1140451 | 1140451 | 2021-03-20 | Dickson | Tennessee | 47043 | 6407 | 107 |
1137205 | 1137205 | 2021-03-19 | Dickson | Tennessee | 47043 | 6407 | 107 |
1133959 | 1133959 | 2021-03-18 | Dickson | Tennessee | 47043 | 6386 | 107 |
1130711 | 1130711 | 2021-03-17 | Dickson | Tennessee | 47043 | 6383 | 107 |
1127464 | 1127464 | 2021-03-16 | Dickson | Tennessee | 47043 | 6375 | 107 |
1124218 | 1124218 | 2021-03-15 | Dickson | Tennessee | 47043 | 6367 | 107 |
1120972 | 1120972 | 2021-03-14 | Dickson | Tennessee | 47043 | 6355 | 107 |
1117725 | 1117725 | 2021-03-13 | Dickson | Tennessee | 47043 | 6355 | 107 |
1114478 | 1114478 | 2021-03-12 | Dickson | Tennessee | 47043 | 6355 | 107 |
1111232 | 1111232 | 2021-03-11 | Dickson | Tennessee | 47043 | 6344 | 107 |
1107986 | 1107986 | 2021-03-10 | Dickson | Tennessee | 47043 | 6337 | 107 |
1104740 | 1104740 | 2021-03-09 | Dickson | Tennessee | 47043 | 6323 | 107 |
1101494 | 1101494 | 2021-03-08 | Dickson | Tennessee | 47043 | 6308 | 106 |
1098248 | 1098248 | 2021-03-07 | Dickson | Tennessee | 47043 | 6303 | 106 |
1095000 | 1095000 | 2021-03-06 | Dickson | Tennessee | 47043 | 6295 | 106 |
1091754 | 1091754 | 2021-03-05 | Dickson | Tennessee | 47043 | 6274 | 106 |
1088508 | 1088508 | 2021-03-04 | Dickson | Tennessee | 47043 | 6256 | 106 |
1085263 | 1085263 | 2021-03-03 | Dickson | Tennessee | 47043 | 6239 | 106 |
1082017 | 1082017 | 2021-03-02 | Dickson | Tennessee | 47043 | 6228 | 106 |
1078771 | 1078771 | 2021-03-01 | Dickson | Tennessee | 47043 | 6217 | 106 |
1075526 | 1075526 | 2021-02-28 | Dickson | Tennessee | 47043 | 6205 | 106 |
1072280 | 1072280 | 2021-02-27 | Dickson | Tennessee | 47043 | 6197 | 106 |
1069034 | 1069034 | 2021-02-26 | Dickson | Tennessee | 47043 | 6183 | 106 |
1065789 | 1065789 | 2021-02-25 | Dickson | Tennessee | 47043 | 6169 | 103 |
1062544 | 1062544 | 2021-02-24 | Dickson | Tennessee | 47043 | 6148 | 103 |
1059299 | 1059299 | 2021-02-23 | Dickson | Tennessee | 47043 | 6118 | 103 |
1056053 | 1056053 | 2021-02-22 | Dickson | Tennessee | 47043 | 6103 | 102 |
1052807 | 1052807 | 2021-02-21 | Dickson | Tennessee | 47043 | 6096 | 102 |
1049560 | 1049560 | 2021-02-20 | Dickson | Tennessee | 47043 | 6088 | 102 |
1046313 | 1046313 | 2021-02-19 | Dickson | Tennessee | 47043 | 6064 | 102 |
1043068 | 1043068 | 2021-02-18 | Dickson | Tennessee | 47043 | 6053 | 102 |
1039823 | 1039823 | 2021-02-17 | Dickson | Tennessee | 47043 | 6044 | 102 |
1036578 | 1036578 | 2021-02-16 | Dickson | Tennessee | 47043 | 6035 | 102 |
1033333 | 1033333 | 2021-02-15 | Dickson | Tennessee | 47043 | 6026 | 102 |
1030087 | 1030087 | 2021-02-14 | Dickson | Tennessee | 47043 | 6018 | 102 |
1026840 | 1026840 | 2021-02-13 | Dickson | Tennessee | 47043 | 6015 | 102 |
1023595 | 1023595 | 2021-02-12 | Dickson | Tennessee | 47043 | 5997 | 102 |
1020350 | 1020350 | 2021-02-11 | Dickson | Tennessee | 47043 | 5953 | 100 |
1017105 | 1017105 | 2021-02-10 | Dickson | Tennessee | 47043 | 5915 | 99 |
1013860 | 1013860 | 2021-02-09 | Dickson | Tennessee | 47043 | 5900 | 98 |
1010615 | 1010615 | 2021-02-08 | Dickson | Tennessee | 47043 | 5895 | 98 |
1007369 | 1007369 | 2021-02-07 | Dickson | Tennessee | 47043 | 5892 | 98 |
1004123 | 1004123 | 2021-02-06 | Dickson | Tennessee | 47043 | 5882 | 98 |
1000877 | 1000877 | 2021-02-05 | Dickson | Tennessee | 47043 | 5861 | 98 |
997631 | 997631 | 2021-02-04 | Dickson | Tennessee | 47043 | 5844 | 92 |
994385 | 994385 | 2021-02-03 | Dickson | Tennessee | 47043 | 5825 | 92 |
991139 | 991139 | 2021-02-02 | Dickson | Tennessee | 47043 | 5784 | 90 |
987893 | 987893 | 2021-02-01 | Dickson | Tennessee | 47043 | 5773 | 87 |
984646 | 984646 | 2021-01-31 | Dickson | Tennessee | 47043 | 5760 | 87 |
981399 | 981399 | 2021-01-30 | Dickson | Tennessee | 47043 | 5743 | 86 |
978153 | 978153 | 2021-01-29 | Dickson | Tennessee | 47043 | 5724 | 85 |
974908 | 974908 | 2021-01-28 | Dickson | Tennessee | 47043 | 5631 | 85 |
971663 | 971663 | 2021-01-27 | Dickson | Tennessee | 47043 | 5624 | 85 |
968418 | 968418 | 2021-01-26 | Dickson | Tennessee | 47043 | 5602 | 85 |
965174 | 965174 | 2021-01-25 | Dickson | Tennessee | 47043 | 5590 | 82 |
961929 | 961929 | 2021-01-24 | Dickson | Tennessee | 47043 | 5584 | 82 |
958684 | 958684 | 2021-01-23 | Dickson | Tennessee | 47043 | 5570 | 82 |
955438 | 955438 | 2021-01-22 | Dickson | Tennessee | 47043 | 5526 | 82 |
952193 | 952193 | 2021-01-21 | Dickson | Tennessee | 47043 | 5495 | 80 |
948948 | 948948 | 2021-01-20 | Dickson | Tennessee | 47043 | 5435 | 79 |
945702 | 945702 | 2021-01-19 | Dickson | Tennessee | 47043 | 5404 | 79 |
942455 | 942455 | 2021-01-18 | Dickson | Tennessee | 47043 | 5363 | 78 |
939210 | 939210 | 2021-01-17 | Dickson | Tennessee | 47043 | 5346 | 78 |
935965 | 935965 | 2021-01-16 | Dickson | Tennessee | 47043 | 5326 | 77 |
932720 | 932720 | 2021-01-15 | Dickson | Tennessee | 47043 | 5292 | 77 |
929475 | 929475 | 2021-01-14 | Dickson | Tennessee | 47043 | 5247 | 77 |
926230 | 926230 | 2021-01-13 | Dickson | Tennessee | 47043 | 5196 | 75 |
922984 | 922984 | 2021-01-12 | Dickson | Tennessee | 47043 | 5156 | 75 |
919739 | 919739 | 2021-01-11 | Dickson | Tennessee | 47043 | 5133 | 74 |
916494 | 916494 | 2021-01-10 | Dickson | Tennessee | 47043 | 5120 | 74 |
913249 | 913249 | 2021-01-09 | Dickson | Tennessee | 47043 | 5083 | 72 |
910004 | 910004 | 2021-01-08 | Dickson | Tennessee | 47043 | 5041 | 70 |
906759 | 906759 | 2021-01-07 | Dickson | Tennessee | 47043 | 4977 | 68 |
903513 | 903513 | 2021-01-06 | Dickson | Tennessee | 47043 | 4927 | 68 |
900268 | 900268 | 2021-01-05 | Dickson | Tennessee | 47043 | 4859 | 65 |
897023 | 897023 | 2021-01-04 | Dickson | Tennessee | 47043 | 4828 | 63 |
893777 | 893777 | 2021-01-03 | Dickson | Tennessee | 47043 | 4803 | 61 |
890531 | 890531 | 2021-01-02 | Dickson | Tennessee | 47043 | 4770 | 61 |
887284 | 887284 | 2021-01-01 | Dickson | Tennessee | 47043 | 4624 | 59 |
884039 | 884039 | 2020-12-31 | Dickson | Tennessee | 47043 | 4624 | 59 |
880794 | 880794 | 2020-12-30 | Dickson | Tennessee | 47043 | 4593 | 59 |
877549 | 877549 | 2020-12-29 | Dickson | Tennessee | 47043 | 4545 | 59 |
874304 | 874304 | 2020-12-28 | Dickson | Tennessee | 47043 | 4505 | 58 |
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);