ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
779 rows where county = "Washington" and state = "Virginia" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
923486 | 923486 | 2021-01-12 | Washington | Virginia | 51191 | 3457 | 58 |
920241 | 920241 | 2021-01-11 | Washington | Virginia | 51191 | 3447 | 58 |
916996 | 916996 | 2021-01-10 | Washington | Virginia | 51191 | 3414 | 58 |
913751 | 913751 | 2021-01-09 | Washington | Virginia | 51191 | 3373 | 58 |
910506 | 910506 | 2021-01-08 | Washington | Virginia | 51191 | 3336 | 56 |
907261 | 907261 | 2021-01-07 | Washington | Virginia | 51191 | 3287 | 55 |
904015 | 904015 | 2021-01-06 | Washington | Virginia | 51191 | 3217 | 55 |
900770 | 900770 | 2021-01-05 | Washington | Virginia | 51191 | 3169 | 54 |
897525 | 897525 | 2021-01-04 | Washington | Virginia | 51191 | 3139 | 51 |
894279 | 894279 | 2021-01-03 | Washington | Virginia | 51191 | 3108 | 48 |
891033 | 891033 | 2021-01-02 | Washington | Virginia | 51191 | 3058 | 47 |
887786 | 887786 | 2021-01-01 | Washington | Virginia | 51191 | 3058 | 46 |
884541 | 884541 | 2020-12-31 | Washington | Virginia | 51191 | 2970 | 44 |
881296 | 881296 | 2020-12-30 | Washington | Virginia | 51191 | 2909 | 44 |
878051 | 878051 | 2020-12-29 | Washington | Virginia | 51191 | 2876 | 44 |
874806 | 874806 | 2020-12-28 | Washington | Virginia | 51191 | 2850 | 43 |
871561 | 871561 | 2020-12-27 | Washington | Virginia | 51191 | 2817 | 43 |
868316 | 868316 | 2020-12-26 | Washington | Virginia | 51191 | 2763 | 40 |
865071 | 865071 | 2020-12-25 | Washington | Virginia | 51191 | 2763 | 40 |
861826 | 861826 | 2020-12-24 | Washington | Virginia | 51191 | 2747 | 40 |
858581 | 858581 | 2020-12-23 | Washington | Virginia | 51191 | 2672 | 40 |
855336 | 855336 | 2020-12-22 | Washington | Virginia | 51191 | 2634 | 40 |
852091 | 852091 | 2020-12-21 | Washington | Virginia | 51191 | 2612 | 40 |
848846 | 848846 | 2020-12-20 | Washington | Virginia | 51191 | 2595 | 40 |
845601 | 845601 | 2020-12-19 | Washington | Virginia | 51191 | 2552 | 38 |
842355 | 842355 | 2020-12-18 | Washington | Virginia | 51191 | 2496 | 38 |
839110 | 839110 | 2020-12-17 | Washington | Virginia | 51191 | 2463 | 37 |
835864 | 835864 | 2020-12-16 | Washington | Virginia | 51191 | 2408 | 37 |
832618 | 832618 | 2020-12-15 | Washington | Virginia | 51191 | 2359 | 37 |
829371 | 829371 | 2020-12-14 | Washington | Virginia | 51191 | 2355 | 36 |
826125 | 826125 | 2020-12-13 | Washington | Virginia | 51191 | 2311 | 36 |
822878 | 822878 | 2020-12-12 | Washington | Virginia | 51191 | 2280 | 35 |
819632 | 819632 | 2020-12-11 | Washington | Virginia | 51191 | 2221 | 34 |
816386 | 816386 | 2020-12-10 | Washington | Virginia | 51191 | 2179 | 34 |
813140 | 813140 | 2020-12-09 | Washington | Virginia | 51191 | 2116 | 34 |
809896 | 809896 | 2020-12-08 | Washington | Virginia | 51191 | 2079 | 34 |
806651 | 806651 | 2020-12-07 | Washington | Virginia | 51191 | 2049 | 34 |
803406 | 803406 | 2020-12-06 | Washington | Virginia | 51191 | 2016 | 34 |
800161 | 800161 | 2020-12-05 | Washington | Virginia | 51191 | 1966 | 34 |
796916 | 796916 | 2020-12-04 | Washington | Virginia | 51191 | 1874 | 34 |
793671 | 793671 | 2020-12-03 | Washington | Virginia | 51191 | 1827 | 34 |
790426 | 790426 | 2020-12-02 | Washington | Virginia | 51191 | 1806 | 31 |
787181 | 787181 | 2020-12-01 | Washington | Virginia | 51191 | 1777 | 31 |
783937 | 783937 | 2020-11-30 | Washington | Virginia | 51191 | 1756 | 31 |
780692 | 780692 | 2020-11-29 | Washington | Virginia | 51191 | 1725 | 31 |
777446 | 777446 | 2020-11-28 | Washington | Virginia | 51191 | 1721 | 31 |
774201 | 774201 | 2020-11-27 | Washington | Virginia | 51191 | 1685 | 31 |
770956 | 770956 | 2020-11-26 | Washington | Virginia | 51191 | 1669 | 31 |
767710 | 767710 | 2020-11-25 | Washington | Virginia | 51191 | 1645 | 30 |
764465 | 764465 | 2020-11-24 | Washington | Virginia | 51191 | 1621 | 30 |
761220 | 761220 | 2020-11-23 | Washington | Virginia | 51191 | 1610 | 29 |
757975 | 757975 | 2020-11-22 | Washington | Virginia | 51191 | 1592 | 29 |
754728 | 754728 | 2020-11-21 | Washington | Virginia | 51191 | 1558 | 29 |
751482 | 751482 | 2020-11-20 | Washington | Virginia | 51191 | 1544 | 29 |
748236 | 748236 | 2020-11-19 | Washington | Virginia | 51191 | 1521 | 29 |
744990 | 744990 | 2020-11-18 | Washington | Virginia | 51191 | 1499 | 29 |
741743 | 741743 | 2020-11-17 | Washington | Virginia | 51191 | 1478 | 29 |
738496 | 738496 | 2020-11-16 | Washington | Virginia | 51191 | 1471 | 29 |
735252 | 735252 | 2020-11-15 | Washington | Virginia | 51191 | 1439 | 28 |
732006 | 732006 | 2020-11-14 | Washington | Virginia | 51191 | 1416 | 28 |
728761 | 728761 | 2020-11-13 | Washington | Virginia | 51191 | 1374 | 28 |
725518 | 725518 | 2020-11-12 | Washington | Virginia | 51191 | 1361 | 28 |
722275 | 722275 | 2020-11-11 | Washington | Virginia | 51191 | 1342 | 28 |
719032 | 719032 | 2020-11-10 | Washington | Virginia | 51191 | 1304 | 28 |
715789 | 715789 | 2020-11-09 | Washington | Virginia | 51191 | 1285 | 28 |
712545 | 712545 | 2020-11-08 | Washington | Virginia | 51191 | 1233 | 28 |
709301 | 709301 | 2020-11-07 | Washington | Virginia | 51191 | 1225 | 28 |
706057 | 706057 | 2020-11-06 | Washington | Virginia | 51191 | 1188 | 28 |
702814 | 702814 | 2020-11-05 | Washington | Virginia | 51191 | 1158 | 28 |
699571 | 699571 | 2020-11-04 | Washington | Virginia | 51191 | 1144 | 28 |
696327 | 696327 | 2020-11-03 | Washington | Virginia | 51191 | 1122 | 28 |
693085 | 693085 | 2020-11-02 | Washington | Virginia | 51191 | 1105 | 26 |
689841 | 689841 | 2020-11-01 | Washington | Virginia | 51191 | 1078 | 26 |
686596 | 686596 | 2020-10-31 | Washington | Virginia | 51191 | 1055 | 26 |
683353 | 683353 | 2020-10-30 | Washington | Virginia | 51191 | 1019 | 26 |
680110 | 680110 | 2020-10-29 | Washington | Virginia | 51191 | 1010 | 26 |
676867 | 676867 | 2020-10-28 | Washington | Virginia | 51191 | 994 | 26 |
673624 | 673624 | 2020-10-27 | Washington | Virginia | 51191 | 980 | 26 |
670382 | 670382 | 2020-10-26 | Washington | Virginia | 51191 | 979 | 26 |
667139 | 667139 | 2020-10-25 | Washington | Virginia | 51191 | 962 | 26 |
663894 | 663894 | 2020-10-24 | Washington | Virginia | 51191 | 934 | 26 |
660650 | 660650 | 2020-10-23 | Washington | Virginia | 51191 | 899 | 26 |
657406 | 657406 | 2020-10-22 | Washington | Virginia | 51191 | 867 | 26 |
654161 | 654161 | 2020-10-21 | Washington | Virginia | 51191 | 850 | 26 |
650916 | 650916 | 2020-10-20 | Washington | Virginia | 51191 | 845 | 25 |
647672 | 647672 | 2020-10-19 | Washington | Virginia | 51191 | 841 | 23 |
644426 | 644426 | 2020-10-18 | Washington | Virginia | 51191 | 833 | 22 |
641178 | 641178 | 2020-10-17 | Washington | Virginia | 51191 | 823 | 22 |
637931 | 637931 | 2020-10-16 | Washington | Virginia | 51191 | 800 | 21 |
634686 | 634686 | 2020-10-15 | Washington | Virginia | 51191 | 778 | 21 |
631441 | 631441 | 2020-10-14 | Washington | Virginia | 51191 | 758 | 21 |
628197 | 628197 | 2020-10-13 | Washington | Virginia | 51191 | 742 | 21 |
624954 | 624954 | 2020-10-12 | Washington | Virginia | 51191 | 735 | 21 |
621711 | 621711 | 2020-10-11 | Washington | Virginia | 51191 | 725 | 21 |
618468 | 618468 | 2020-10-10 | Washington | Virginia | 51191 | 714 | 21 |
615226 | 615226 | 2020-10-09 | Washington | Virginia | 51191 | 699 | 21 |
611985 | 611985 | 2020-10-08 | Washington | Virginia | 51191 | 685 | 21 |
608743 | 608743 | 2020-10-07 | Washington | Virginia | 51191 | 660 | 21 |
605500 | 605500 | 2020-10-06 | Washington | Virginia | 51191 | 651 | 21 |
602258 | 602258 | 2020-10-05 | Washington | Virginia | 51191 | 643 | 21 |
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);