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 |
---|---|---|---|---|---|---|---|
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 |
955858 | 955858 | 2021-01-22 | Franklin | Virginia | 51067 | 3102 | 31 |
952613 | 952613 | 2021-01-21 | Franklin | Virginia | 51067 | 3079 | 29 |
949368 | 949368 | 2021-01-20 | Franklin | Virginia | 51067 | 3045 | 29 |
946122 | 946122 | 2021-01-19 | Franklin | Virginia | 51067 | 3001 | 28 |
942875 | 942875 | 2021-01-18 | Franklin | Virginia | 51067 | 2972 | 28 |
939630 | 939630 | 2021-01-17 | Franklin | Virginia | 51067 | 2942 | 28 |
936385 | 936385 | 2021-01-16 | Franklin | Virginia | 51067 | 2902 | 28 |
933140 | 933140 | 2021-01-15 | Franklin | Virginia | 51067 | 2854 | 28 |
929895 | 929895 | 2021-01-14 | Franklin | Virginia | 51067 | 2822 | 28 |
926650 | 926650 | 2021-01-13 | Franklin | Virginia | 51067 | 2788 | 28 |
923404 | 923404 | 2021-01-12 | Franklin | Virginia | 51067 | 2746 | 27 |
920159 | 920159 | 2021-01-11 | Franklin | Virginia | 51067 | 2716 | 25 |
916914 | 916914 | 2021-01-10 | Franklin | Virginia | 51067 | 2686 | 25 |
913669 | 913669 | 2021-01-09 | Franklin | Virginia | 51067 | 2648 | 25 |
910424 | 910424 | 2021-01-08 | Franklin | Virginia | 51067 | 2594 | 25 |
907179 | 907179 | 2021-01-07 | Franklin | Virginia | 51067 | 2528 | 25 |
903933 | 903933 | 2021-01-06 | Franklin | Virginia | 51067 | 2494 | 24 |
900688 | 900688 | 2021-01-05 | Franklin | Virginia | 51067 | 2463 | 24 |
897443 | 897443 | 2021-01-04 | Franklin | Virginia | 51067 | 2426 | 24 |
894197 | 894197 | 2021-01-03 | Franklin | Virginia | 51067 | 2412 | 24 |
890951 | 890951 | 2021-01-02 | Franklin | Virginia | 51067 | 2387 | 24 |
887704 | 887704 | 2021-01-01 | Franklin | Virginia | 51067 | 2366 | 23 |
884459 | 884459 | 2020-12-31 | Franklin | Virginia | 51067 | 2329 | 22 |
881214 | 881214 | 2020-12-30 | Franklin | Virginia | 51067 | 2301 | 22 |
877969 | 877969 | 2020-12-29 | Franklin | Virginia | 51067 | 2292 | 22 |
874724 | 874724 | 2020-12-28 | Franklin | Virginia | 51067 | 2273 | 22 |
871479 | 871479 | 2020-12-27 | Franklin | Virginia | 51067 | 2267 | 22 |
868234 | 868234 | 2020-12-26 | Franklin | Virginia | 51067 | 2255 | 22 |
864989 | 864989 | 2020-12-25 | Franklin | Virginia | 51067 | 2244 | 22 |
861744 | 861744 | 2020-12-24 | Franklin | Virginia | 51067 | 2207 | 21 |
858499 | 858499 | 2020-12-23 | Franklin | Virginia | 51067 | 2180 | 20 |
855254 | 855254 | 2020-12-22 | Franklin | Virginia | 51067 | 2129 | 20 |
852009 | 852009 | 2020-12-21 | Franklin | Virginia | 51067 | 2109 | 20 |
848764 | 848764 | 2020-12-20 | Franklin | Virginia | 51067 | 2084 | 20 |
845519 | 845519 | 2020-12-19 | Franklin | Virginia | 51067 | 2073 | 20 |
842273 | 842273 | 2020-12-18 | Franklin | Virginia | 51067 | 2036 | 20 |
839028 | 839028 | 2020-12-17 | Franklin | Virginia | 51067 | 2025 | 20 |
835782 | 835782 | 2020-12-16 | Franklin | Virginia | 51067 | 1994 | 20 |
832536 | 832536 | 2020-12-15 | Franklin | Virginia | 51067 | 1968 | 20 |
829289 | 829289 | 2020-12-14 | Franklin | Virginia | 51067 | 1957 | 20 |
826043 | 826043 | 2020-12-13 | Franklin | Virginia | 51067 | 1943 | 20 |
822796 | 822796 | 2020-12-12 | Franklin | Virginia | 51067 | 1910 | 20 |
819550 | 819550 | 2020-12-11 | Franklin | Virginia | 51067 | 1880 | 19 |
816304 | 816304 | 2020-12-10 | Franklin | Virginia | 51067 | 1854 | 19 |
813058 | 813058 | 2020-12-09 | Franklin | Virginia | 51067 | 1817 | 17 |
809814 | 809814 | 2020-12-08 | Franklin | Virginia | 51067 | 1797 | 17 |
806569 | 806569 | 2020-12-07 | Franklin | Virginia | 51067 | 1774 | 17 |
803324 | 803324 | 2020-12-06 | Franklin | Virginia | 51067 | 1749 | 17 |
800079 | 800079 | 2020-12-05 | Franklin | Virginia | 51067 | 1719 | 17 |
796834 | 796834 | 2020-12-04 | Franklin | Virginia | 51067 | 1710 | 17 |
793589 | 793589 | 2020-12-03 | Franklin | Virginia | 51067 | 1675 | 17 |
790344 | 790344 | 2020-12-02 | Franklin | Virginia | 51067 | 1655 | 17 |
787099 | 787099 | 2020-12-01 | Franklin | Virginia | 51067 | 1642 | 17 |
783855 | 783855 | 2020-11-30 | Franklin | Virginia | 51067 | 1634 | 17 |
780610 | 780610 | 2020-11-29 | Franklin | Virginia | 51067 | 1621 | 17 |
777364 | 777364 | 2020-11-28 | Franklin | Virginia | 51067 | 1611 | 17 |
774119 | 774119 | 2020-11-27 | Franklin | Virginia | 51067 | 1582 | 17 |
770874 | 770874 | 2020-11-26 | Franklin | Virginia | 51067 | 1557 | 17 |
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);