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 |
---|---|---|---|---|---|---|---|
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 |
767628 | 767628 | 2020-11-25 | Franklin | Virginia | 51067 | 1514 | 17 |
764383 | 764383 | 2020-11-24 | Franklin | Virginia | 51067 | 1469 | 16 |
761138 | 761138 | 2020-11-23 | Franklin | Virginia | 51067 | 1450 | 13 |
757893 | 757893 | 2020-11-22 | Franklin | Virginia | 51067 | 1439 | 13 |
754646 | 754646 | 2020-11-21 | Franklin | Virginia | 51067 | 1397 | 13 |
751400 | 751400 | 2020-11-20 | Franklin | Virginia | 51067 | 1374 | 12 |
748154 | 748154 | 2020-11-19 | Franklin | Virginia | 51067 | 1343 | 11 |
744908 | 744908 | 2020-11-18 | Franklin | Virginia | 51067 | 1291 | 10 |
741661 | 741661 | 2020-11-17 | Franklin | Virginia | 51067 | 1275 | 10 |
738414 | 738414 | 2020-11-16 | Franklin | Virginia | 51067 | 1270 | 9 |
735170 | 735170 | 2020-11-15 | Franklin | Virginia | 51067 | 1251 | 9 |
731924 | 731924 | 2020-11-14 | Franklin | Virginia | 51067 | 1233 | 9 |
728679 | 728679 | 2020-11-13 | Franklin | Virginia | 51067 | 1219 | 7 |
725436 | 725436 | 2020-11-12 | Franklin | Virginia | 51067 | 1197 | 7 |
722193 | 722193 | 2020-11-11 | Franklin | Virginia | 51067 | 1178 | 7 |
718950 | 718950 | 2020-11-10 | Franklin | Virginia | 51067 | 1156 | 7 |
715707 | 715707 | 2020-11-09 | Franklin | Virginia | 51067 | 1138 | 7 |
712463 | 712463 | 2020-11-08 | Franklin | Virginia | 51067 | 1121 | 7 |
709219 | 709219 | 2020-11-07 | Franklin | Virginia | 51067 | 1112 | 7 |
705975 | 705975 | 2020-11-06 | Franklin | Virginia | 51067 | 1090 | 7 |
702732 | 702732 | 2020-11-05 | Franklin | Virginia | 51067 | 1066 | 7 |
699489 | 699489 | 2020-11-04 | Franklin | Virginia | 51067 | 1042 | 6 |
696245 | 696245 | 2020-11-03 | Franklin | Virginia | 51067 | 999 | 7 |
693003 | 693003 | 2020-11-02 | Franklin | Virginia | 51067 | 963 | 6 |
689759 | 689759 | 2020-11-01 | Franklin | Virginia | 51067 | 945 | 6 |
686514 | 686514 | 2020-10-31 | Franklin | Virginia | 51067 | 921 | 6 |
683271 | 683271 | 2020-10-30 | Franklin | Virginia | 51067 | 902 | 6 |
680028 | 680028 | 2020-10-29 | Franklin | Virginia | 51067 | 886 | 6 |
676785 | 676785 | 2020-10-28 | Franklin | Virginia | 51067 | 846 | 6 |
673542 | 673542 | 2020-10-27 | Franklin | Virginia | 51067 | 817 | 6 |
670300 | 670300 | 2020-10-26 | Franklin | Virginia | 51067 | 806 | 5 |
667057 | 667057 | 2020-10-25 | Franklin | Virginia | 51067 | 791 | 5 |
663812 | 663812 | 2020-10-24 | Franklin | Virginia | 51067 | 775 | 5 |
660568 | 660568 | 2020-10-23 | Franklin | Virginia | 51067 | 748 | 5 |
657324 | 657324 | 2020-10-22 | Franklin | Virginia | 51067 | 732 | 5 |
654079 | 654079 | 2020-10-21 | Franklin | Virginia | 51067 | 706 | 5 |
650834 | 650834 | 2020-10-20 | Franklin | Virginia | 51067 | 678 | 4 |
647590 | 647590 | 2020-10-19 | Franklin | Virginia | 51067 | 662 | 4 |
644344 | 644344 | 2020-10-18 | Franklin | Virginia | 51067 | 656 | 4 |
641096 | 641096 | 2020-10-17 | Franklin | Virginia | 51067 | 637 | 4 |
637849 | 637849 | 2020-10-16 | Franklin | Virginia | 51067 | 608 | 4 |
634604 | 634604 | 2020-10-15 | Franklin | Virginia | 51067 | 597 | 4 |
631359 | 631359 | 2020-10-14 | Franklin | Virginia | 51067 | 568 | 4 |
628115 | 628115 | 2020-10-13 | Franklin | Virginia | 51067 | 552 | 4 |
624872 | 624872 | 2020-10-12 | Franklin | Virginia | 51067 | 516 | 4 |
621629 | 621629 | 2020-10-11 | Franklin | Virginia | 51067 | 501 | 4 |
618386 | 618386 | 2020-10-10 | Franklin | Virginia | 51067 | 490 | 4 |
615144 | 615144 | 2020-10-09 | Franklin | Virginia | 51067 | 471 | 4 |
611903 | 611903 | 2020-10-08 | Franklin | Virginia | 51067 | 459 | 4 |
608661 | 608661 | 2020-10-07 | Franklin | Virginia | 51067 | 434 | 4 |
605418 | 605418 | 2020-10-06 | Franklin | Virginia | 51067 | 431 | 4 |
602176 | 602176 | 2020-10-05 | Franklin | Virginia | 51067 | 429 | 4 |
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);