ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
783 rows where county = "Franklin" and fips = 47051 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1195661 | 1195661 | 2021-04-06 | Franklin | Tennessee | 47051 | 5032 | 87 |
1192413 | 1192413 | 2021-04-05 | Franklin | Tennessee | 47051 | 5024 | 87 |
1189164 | 1189164 | 2021-04-04 | Franklin | Tennessee | 47051 | 5009 | 87 |
1185917 | 1185917 | 2021-04-03 | Franklin | Tennessee | 47051 | 5009 | 87 |
1182670 | 1182670 | 2021-04-02 | Franklin | Tennessee | 47051 | 5009 | 87 |
1179423 | 1179423 | 2021-04-01 | Franklin | Tennessee | 47051 | 5009 | 87 |
1176176 | 1176176 | 2021-03-31 | Franklin | Tennessee | 47051 | 4991 | 87 |
1172929 | 1172929 | 2021-03-30 | Franklin | Tennessee | 47051 | 4987 | 87 |
1169682 | 1169682 | 2021-03-29 | Franklin | Tennessee | 47051 | 4980 | 87 |
1166434 | 1166434 | 2021-03-28 | Franklin | Tennessee | 47051 | 4964 | 87 |
1163186 | 1163186 | 2021-03-27 | Franklin | Tennessee | 47051 | 4964 | 87 |
1159937 | 1159937 | 2021-03-26 | Franklin | Tennessee | 47051 | 4964 | 87 |
1156690 | 1156690 | 2021-03-25 | Franklin | Tennessee | 47051 | 4954 | 87 |
1153443 | 1153443 | 2021-03-24 | Franklin | Tennessee | 47051 | 4937 | 87 |
1150196 | 1150196 | 2021-03-23 | Franklin | Tennessee | 47051 | 4929 | 87 |
1146949 | 1146949 | 2021-03-22 | Franklin | Tennessee | 47051 | 4925 | 87 |
1143702 | 1143702 | 2021-03-21 | Franklin | Tennessee | 47051 | 4890 | 87 |
1140455 | 1140455 | 2021-03-20 | Franklin | Tennessee | 47051 | 4890 | 87 |
1137209 | 1137209 | 2021-03-19 | Franklin | Tennessee | 47051 | 4890 | 87 |
1133963 | 1133963 | 2021-03-18 | Franklin | Tennessee | 47051 | 4876 | 87 |
1130715 | 1130715 | 2021-03-17 | Franklin | Tennessee | 47051 | 4872 | 86 |
1127468 | 1127468 | 2021-03-16 | Franklin | Tennessee | 47051 | 4862 | 85 |
1124222 | 1124222 | 2021-03-15 | Franklin | Tennessee | 47051 | 4849 | 85 |
1120976 | 1120976 | 2021-03-14 | Franklin | Tennessee | 47051 | 4819 | 85 |
1117729 | 1117729 | 2021-03-13 | Franklin | Tennessee | 47051 | 4819 | 85 |
1114482 | 1114482 | 2021-03-12 | Franklin | Tennessee | 47051 | 4819 | 85 |
1111236 | 1111236 | 2021-03-11 | Franklin | Tennessee | 47051 | 4811 | 85 |
1107990 | 1107990 | 2021-03-10 | Franklin | Tennessee | 47051 | 4798 | 85 |
1104744 | 1104744 | 2021-03-09 | Franklin | Tennessee | 47051 | 4792 | 85 |
1101498 | 1101498 | 2021-03-08 | Franklin | Tennessee | 47051 | 4780 | 85 |
1098252 | 1098252 | 2021-03-07 | Franklin | Tennessee | 47051 | 4771 | 85 |
1095004 | 1095004 | 2021-03-06 | Franklin | Tennessee | 47051 | 4765 | 85 |
1091758 | 1091758 | 2021-03-05 | Franklin | Tennessee | 47051 | 4754 | 85 |
1088512 | 1088512 | 2021-03-04 | Franklin | Tennessee | 47051 | 4757 | 85 |
1085267 | 1085267 | 2021-03-03 | Franklin | Tennessee | 47051 | 4744 | 85 |
1082021 | 1082021 | 2021-03-02 | Franklin | Tennessee | 47051 | 4736 | 85 |
1078775 | 1078775 | 2021-03-01 | Franklin | Tennessee | 47051 | 4729 | 85 |
1075530 | 1075530 | 2021-02-28 | Franklin | Tennessee | 47051 | 4725 | 85 |
1072284 | 1072284 | 2021-02-27 | Franklin | Tennessee | 47051 | 4721 | 85 |
1069038 | 1069038 | 2021-02-26 | Franklin | Tennessee | 47051 | 4714 | 85 |
1065793 | 1065793 | 2021-02-25 | Franklin | Tennessee | 47051 | 4708 | 84 |
1062548 | 1062548 | 2021-02-24 | Franklin | Tennessee | 47051 | 4706 | 84 |
1059303 | 1059303 | 2021-02-23 | Franklin | Tennessee | 47051 | 4699 | 83 |
1056057 | 1056057 | 2021-02-22 | Franklin | Tennessee | 47051 | 4684 | 80 |
1052811 | 1052811 | 2021-02-21 | Franklin | Tennessee | 47051 | 4679 | 80 |
1049564 | 1049564 | 2021-02-20 | Franklin | Tennessee | 47051 | 4668 | 80 |
1046317 | 1046317 | 2021-02-19 | Franklin | Tennessee | 47051 | 4651 | 80 |
1043072 | 1043072 | 2021-02-18 | Franklin | Tennessee | 47051 | 4644 | 80 |
1039827 | 1039827 | 2021-02-17 | Franklin | Tennessee | 47051 | 4627 | 80 |
1036582 | 1036582 | 2021-02-16 | Franklin | Tennessee | 47051 | 4622 | 79 |
1033337 | 1033337 | 2021-02-15 | Franklin | Tennessee | 47051 | 4616 | 79 |
1030091 | 1030091 | 2021-02-14 | Franklin | Tennessee | 47051 | 4603 | 79 |
1026844 | 1026844 | 2021-02-13 | Franklin | Tennessee | 47051 | 4593 | 79 |
1023599 | 1023599 | 2021-02-12 | Franklin | Tennessee | 47051 | 4585 | 79 |
1020354 | 1020354 | 2021-02-11 | Franklin | Tennessee | 47051 | 4577 | 79 |
1017109 | 1017109 | 2021-02-10 | Franklin | Tennessee | 47051 | 4550 | 78 |
1013864 | 1013864 | 2021-02-09 | Franklin | Tennessee | 47051 | 4499 | 76 |
1010619 | 1010619 | 2021-02-08 | Franklin | Tennessee | 47051 | 4477 | 76 |
1007373 | 1007373 | 2021-02-07 | Franklin | Tennessee | 47051 | 4470 | 76 |
1004127 | 1004127 | 2021-02-06 | Franklin | Tennessee | 47051 | 4458 | 76 |
1000881 | 1000881 | 2021-02-05 | Franklin | Tennessee | 47051 | 4434 | 74 |
997635 | 997635 | 2021-02-04 | Franklin | Tennessee | 47051 | 4422 | 74 |
994389 | 994389 | 2021-02-03 | Franklin | Tennessee | 47051 | 4401 | 72 |
991143 | 991143 | 2021-02-02 | Franklin | Tennessee | 47051 | 4385 | 71 |
987897 | 987897 | 2021-02-01 | Franklin | Tennessee | 47051 | 4370 | 70 |
984650 | 984650 | 2021-01-31 | Franklin | Tennessee | 47051 | 4367 | 70 |
981403 | 981403 | 2021-01-30 | Franklin | Tennessee | 47051 | 4347 | 69 |
978157 | 978157 | 2021-01-29 | Franklin | Tennessee | 47051 | 4340 | 69 |
974912 | 974912 | 2021-01-28 | Franklin | Tennessee | 47051 | 4305 | 69 |
971667 | 971667 | 2021-01-27 | Franklin | Tennessee | 47051 | 4294 | 69 |
968422 | 968422 | 2021-01-26 | Franklin | Tennessee | 47051 | 4277 | 68 |
965178 | 965178 | 2021-01-25 | Franklin | Tennessee | 47051 | 4260 | 67 |
961933 | 961933 | 2021-01-24 | Franklin | Tennessee | 47051 | 4249 | 65 |
958688 | 958688 | 2021-01-23 | Franklin | Tennessee | 47051 | 4228 | 65 |
955442 | 955442 | 2021-01-22 | Franklin | Tennessee | 47051 | 4200 | 65 |
952197 | 952197 | 2021-01-21 | Franklin | Tennessee | 47051 | 4168 | 65 |
948952 | 948952 | 2021-01-20 | Franklin | Tennessee | 47051 | 4152 | 63 |
945706 | 945706 | 2021-01-19 | Franklin | Tennessee | 47051 | 4130 | 62 |
942459 | 942459 | 2021-01-18 | Franklin | Tennessee | 47051 | 4121 | 61 |
939214 | 939214 | 2021-01-17 | Franklin | Tennessee | 47051 | 4107 | 58 |
935969 | 935969 | 2021-01-16 | Franklin | Tennessee | 47051 | 4079 | 58 |
932724 | 932724 | 2021-01-15 | Franklin | Tennessee | 47051 | 4035 | 56 |
929479 | 929479 | 2021-01-14 | Franklin | Tennessee | 47051 | 3999 | 56 |
926234 | 926234 | 2021-01-13 | Franklin | Tennessee | 47051 | 3970 | 53 |
922988 | 922988 | 2021-01-12 | Franklin | Tennessee | 47051 | 3941 | 51 |
919743 | 919743 | 2021-01-11 | Franklin | Tennessee | 47051 | 3925 | 51 |
916498 | 916498 | 2021-01-10 | Franklin | Tennessee | 47051 | 3913 | 51 |
913253 | 913253 | 2021-01-09 | Franklin | Tennessee | 47051 | 3874 | 50 |
910008 | 910008 | 2021-01-08 | Franklin | Tennessee | 47051 | 3847 | 50 |
906763 | 906763 | 2021-01-07 | Franklin | Tennessee | 47051 | 3806 | 49 |
903517 | 903517 | 2021-01-06 | Franklin | Tennessee | 47051 | 3751 | 49 |
900272 | 900272 | 2021-01-05 | Franklin | Tennessee | 47051 | 3726 | 48 |
897027 | 897027 | 2021-01-04 | Franklin | Tennessee | 47051 | 3689 | 48 |
893781 | 893781 | 2021-01-03 | Franklin | Tennessee | 47051 | 3664 | 48 |
890535 | 890535 | 2021-01-02 | Franklin | Tennessee | 47051 | 3638 | 48 |
887288 | 887288 | 2021-01-01 | Franklin | Tennessee | 47051 | 3549 | 48 |
884043 | 884043 | 2020-12-31 | Franklin | Tennessee | 47051 | 3549 | 48 |
880798 | 880798 | 2020-12-30 | Franklin | Tennessee | 47051 | 3491 | 48 |
877553 | 877553 | 2020-12-29 | Franklin | Tennessee | 47051 | 3448 | 48 |
874308 | 874308 | 2020-12-28 | Franklin | Tennessee | 47051 | 3423 | 46 |
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);