ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
784 rows where county = "Franklin" and state = "Virginia" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1280512 | 1280512 | 2021-05-02 | Franklin | Virginia | 51067 | 3997 | 74 |
1277265 | 1277265 | 2021-05-01 | Franklin | Virginia | 51067 | 3994 | 74 |
1274018 | 1274018 | 2021-04-30 | Franklin | Virginia | 51067 | 3986 | 74 |
1270771 | 1270771 | 2021-04-29 | Franklin | Virginia | 51067 | 3981 | 74 |
1267524 | 1267524 | 2021-04-28 | Franklin | Virginia | 51067 | 3979 | 74 |
1264277 | 1264277 | 2021-04-27 | Franklin | Virginia | 51067 | 3972 | 74 |
1261030 | 1261030 | 2021-04-26 | Franklin | Virginia | 51067 | 3970 | 74 |
1257783 | 1257783 | 2021-04-25 | Franklin | Virginia | 51067 | 3968 | 74 |
1254536 | 1254536 | 2021-04-24 | Franklin | Virginia | 51067 | 3967 | 74 |
1251289 | 1251289 | 2021-04-23 | Franklin | Virginia | 51067 | 3964 | 74 |
1248042 | 1248042 | 2021-04-22 | Franklin | Virginia | 51067 | 3963 | 74 |
1244795 | 1244795 | 2021-04-21 | Franklin | Virginia | 51067 | 3963 | 74 |
1241548 | 1241548 | 2021-04-20 | Franklin | Virginia | 51067 | 3957 | 74 |
1238301 | 1238301 | 2021-04-19 | Franklin | Virginia | 51067 | 3952 | 74 |
1235054 | 1235054 | 2021-04-18 | Franklin | Virginia | 51067 | 3946 | 74 |
1231806 | 1231806 | 2021-04-17 | Franklin | Virginia | 51067 | 3941 | 74 |
1228558 | 1228558 | 2021-04-16 | Franklin | Virginia | 51067 | 3940 | 73 |
1225310 | 1225310 | 2021-04-15 | Franklin | Virginia | 51067 | 3931 | 73 |
1222063 | 1222063 | 2021-04-14 | Franklin | Virginia | 51067 | 3929 | 73 |
1218815 | 1218815 | 2021-04-13 | Franklin | Virginia | 51067 | 3931 | 72 |
1215567 | 1215567 | 2021-04-12 | Franklin | Virginia | 51067 | 3931 | 72 |
1212320 | 1212320 | 2021-04-11 | Franklin | Virginia | 51067 | 3923 | 72 |
1209071 | 1209071 | 2021-04-10 | Franklin | Virginia | 51067 | 3919 | 72 |
1205823 | 1205823 | 2021-04-09 | Franklin | Virginia | 51067 | 3907 | 72 |
1202575 | 1202575 | 2021-04-08 | Franklin | Virginia | 51067 | 3904 | 72 |
1199327 | 1199327 | 2021-04-07 | Franklin | Virginia | 51067 | 3900 | 72 |
1196078 | 1196078 | 2021-04-06 | Franklin | Virginia | 51067 | 3885 | 72 |
1192830 | 1192830 | 2021-04-05 | Franklin | Virginia | 51067 | 3874 | 72 |
1189580 | 1189580 | 2021-04-04 | Franklin | Virginia | 51067 | 3868 | 72 |
1186333 | 1186333 | 2021-04-03 | Franklin | Virginia | 51067 | 3863 | 72 |
1183086 | 1183086 | 2021-04-02 | Franklin | Virginia | 51067 | 3859 | 72 |
1179839 | 1179839 | 2021-04-01 | Franklin | Virginia | 51067 | 3851 | 72 |
1176592 | 1176592 | 2021-03-31 | Franklin | Virginia | 51067 | 3843 | 72 |
1173345 | 1173345 | 2021-03-30 | Franklin | Virginia | 51067 | 3838 | 72 |
1170098 | 1170098 | 2021-03-29 | Franklin | Virginia | 51067 | 3833 | 72 |
1166850 | 1166850 | 2021-03-28 | Franklin | Virginia | 51067 | 3825 | 71 |
1163602 | 1163602 | 2021-03-27 | Franklin | Virginia | 51067 | 3821 | 71 |
1160354 | 1160354 | 2021-03-26 | Franklin | Virginia | 51067 | 3815 | 71 |
1157106 | 1157106 | 2021-03-25 | Franklin | Virginia | 51067 | 3815 | 71 |
1153859 | 1153859 | 2021-03-24 | Franklin | Virginia | 51067 | 3813 | 71 |
1150612 | 1150612 | 2021-03-23 | Franklin | Virginia | 51067 | 3806 | 71 |
1147365 | 1147365 | 2021-03-22 | Franklin | Virginia | 51067 | 3804 | 71 |
1144118 | 1144118 | 2021-03-21 | Franklin | Virginia | 51067 | 3799 | 71 |
1140871 | 1140871 | 2021-03-20 | Franklin | Virginia | 51067 | 3793 | 71 |
1137625 | 1137625 | 2021-03-19 | Franklin | Virginia | 51067 | 3785 | 71 |
1134379 | 1134379 | 2021-03-18 | Franklin | Virginia | 51067 | 3781 | 70 |
1131131 | 1131131 | 2021-03-17 | Franklin | Virginia | 51067 | 3776 | 70 |
1127884 | 1127884 | 2021-03-16 | Franklin | Virginia | 51067 | 3770 | 70 |
1124638 | 1124638 | 2021-03-15 | Franklin | Virginia | 51067 | 3767 | 69 |
1121392 | 1121392 | 2021-03-14 | Franklin | Virginia | 51067 | 3765 | 68 |
1118145 | 1118145 | 2021-03-13 | Franklin | Virginia | 51067 | 3765 | 68 |
1114898 | 1114898 | 2021-03-12 | Franklin | Virginia | 51067 | 3763 | 68 |
1111652 | 1111652 | 2021-03-11 | Franklin | Virginia | 51067 | 3760 | 68 |
1108406 | 1108406 | 2021-03-10 | Franklin | Virginia | 51067 | 3756 | 64 |
1105160 | 1105160 | 2021-03-09 | Franklin | Virginia | 51067 | 3750 | 63 |
1101914 | 1101914 | 2021-03-08 | Franklin | Virginia | 51067 | 3746 | 63 |
1098668 | 1098668 | 2021-03-07 | Franklin | Virginia | 51067 | 3742 | 61 |
1095420 | 1095420 | 2021-03-06 | Franklin | Virginia | 51067 | 3736 | 60 |
1092174 | 1092174 | 2021-03-05 | Franklin | Virginia | 51067 | 3733 | 58 |
1088928 | 1088928 | 2021-03-04 | Franklin | Virginia | 51067 | 3729 | 57 |
1085683 | 1085683 | 2021-03-03 | Franklin | Virginia | 51067 | 3723 | 57 |
1082437 | 1082437 | 2021-03-02 | Franklin | Virginia | 51067 | 3721 | 54 |
1079191 | 1079191 | 2021-03-01 | Franklin | Virginia | 51067 | 3714 | 53 |
1075946 | 1075946 | 2021-02-28 | Franklin | Virginia | 51067 | 3711 | 52 |
1072700 | 1072700 | 2021-02-27 | Franklin | Virginia | 51067 | 3703 | 51 |
1069454 | 1069454 | 2021-02-26 | Franklin | Virginia | 51067 | 3687 | 51 |
1066209 | 1066209 | 2021-02-25 | Franklin | Virginia | 51067 | 3679 | 47 |
1062964 | 1062964 | 2021-02-24 | Franklin | Virginia | 51067 | 3675 | 46 |
1059719 | 1059719 | 2021-02-23 | Franklin | Virginia | 51067 | 3660 | 44 |
1056473 | 1056473 | 2021-02-22 | Franklin | Virginia | 51067 | 3656 | 44 |
1053227 | 1053227 | 2021-02-21 | Franklin | Virginia | 51067 | 3654 | 43 |
1049980 | 1049980 | 2021-02-20 | Franklin | Virginia | 51067 | 3648 | 42 |
1046733 | 1046733 | 2021-02-19 | Franklin | Virginia | 51067 | 3646 | 42 |
1043488 | 1043488 | 2021-02-18 | Franklin | Virginia | 51067 | 3641 | 42 |
1040243 | 1040243 | 2021-02-17 | Franklin | Virginia | 51067 | 3630 | 42 |
1036998 | 1036998 | 2021-02-16 | Franklin | Virginia | 51067 | 3610 | 42 |
1033753 | 1033753 | 2021-02-15 | Franklin | Virginia | 51067 | 3604 | 42 |
1030507 | 1030507 | 2021-02-14 | Franklin | Virginia | 51067 | 3598 | 42 |
1027260 | 1027260 | 2021-02-13 | Franklin | Virginia | 51067 | 3585 | 42 |
1024015 | 1024015 | 2021-02-12 | Franklin | Virginia | 51067 | 3570 | 41 |
1020770 | 1020770 | 2021-02-11 | Franklin | Virginia | 51067 | 3547 | 41 |
1017525 | 1017525 | 2021-02-10 | Franklin | Virginia | 51067 | 3532 | 41 |
1014280 | 1014280 | 2021-02-09 | Franklin | Virginia | 51067 | 3516 | 40 |
1011035 | 1011035 | 2021-02-08 | Franklin | Virginia | 51067 | 3497 | 39 |
1007789 | 1007789 | 2021-02-07 | Franklin | Virginia | 51067 | 3489 | 39 |
1004543 | 1004543 | 2021-02-06 | Franklin | Virginia | 51067 | 3472 | 39 |
1001297 | 1001297 | 2021-02-05 | Franklin | Virginia | 51067 | 3448 | 37 |
998051 | 998051 | 2021-02-04 | Franklin | Virginia | 51067 | 3420 | 36 |
994805 | 994805 | 2021-02-03 | Franklin | Virginia | 51067 | 3407 | 36 |
991559 | 991559 | 2021-02-02 | Franklin | Virginia | 51067 | 3379 | 35 |
988313 | 988313 | 2021-02-01 | Franklin | Virginia | 51067 | 3360 | 34 |
985066 | 985066 | 2021-01-31 | Franklin | Virginia | 51067 | 3348 | 34 |
981819 | 981819 | 2021-01-30 | Franklin | Virginia | 51067 | 3337 | 34 |
978573 | 978573 | 2021-01-29 | Franklin | Virginia | 51067 | 3290 | 34 |
975328 | 975328 | 2021-01-28 | Franklin | Virginia | 51067 | 3271 | 33 |
972083 | 972083 | 2021-01-27 | Franklin | Virginia | 51067 | 3241 | 32 |
968838 | 968838 | 2021-01-26 | Franklin | Virginia | 51067 | 3206 | 32 |
965594 | 965594 | 2021-01-25 | Franklin | Virginia | 51067 | 3166 | 31 |
962349 | 962349 | 2021-01-24 | Franklin | Virginia | 51067 | 3139 | 31 |
959104 | 959104 | 2021-01-23 | Franklin | Virginia | 51067 | 3116 | 31 |
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);