ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
783 rows where county = "Lee" and state = "Virginia" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
923429 | 923429 | 2021-01-12 | Lee | Virginia | 51105 | 1790 | 32 |
920184 | 920184 | 2021-01-11 | Lee | Virginia | 51105 | 1763 | 32 |
916939 | 916939 | 2021-01-10 | Lee | Virginia | 51105 | 1758 | 32 |
913694 | 913694 | 2021-01-09 | Lee | Virginia | 51105 | 1746 | 32 |
910449 | 910449 | 2021-01-08 | Lee | Virginia | 51105 | 1669 | 32 |
907204 | 907204 | 2021-01-07 | Lee | Virginia | 51105 | 1632 | 32 |
903958 | 903958 | 2021-01-06 | Lee | Virginia | 51105 | 1613 | 31 |
900713 | 900713 | 2021-01-05 | Lee | Virginia | 51105 | 1594 | 31 |
897468 | 897468 | 2021-01-04 | Lee | Virginia | 51105 | 1566 | 30 |
894222 | 894222 | 2021-01-03 | Lee | Virginia | 51105 | 1550 | 30 |
890976 | 890976 | 2021-01-02 | Lee | Virginia | 51105 | 1531 | 30 |
887729 | 887729 | 2021-01-01 | Lee | Virginia | 51105 | 1506 | 29 |
884484 | 884484 | 2020-12-31 | Lee | Virginia | 51105 | 1476 | 29 |
881239 | 881239 | 2020-12-30 | Lee | Virginia | 51105 | 1439 | 29 |
877994 | 877994 | 2020-12-29 | Lee | Virginia | 51105 | 1425 | 29 |
874749 | 874749 | 2020-12-28 | Lee | Virginia | 51105 | 1413 | 29 |
871504 | 871504 | 2020-12-27 | Lee | Virginia | 51105 | 1409 | 29 |
868259 | 868259 | 2020-12-26 | Lee | Virginia | 51105 | 1396 | 29 |
865014 | 865014 | 2020-12-25 | Lee | Virginia | 51105 | 1385 | 29 |
861769 | 861769 | 2020-12-24 | Lee | Virginia | 51105 | 1362 | 28 |
858524 | 858524 | 2020-12-23 | Lee | Virginia | 51105 | 1315 | 28 |
855279 | 855279 | 2020-12-22 | Lee | Virginia | 51105 | 1304 | 28 |
852034 | 852034 | 2020-12-21 | Lee | Virginia | 51105 | 1293 | 26 |
848789 | 848789 | 2020-12-20 | Lee | Virginia | 51105 | 1272 | 26 |
845544 | 845544 | 2020-12-19 | Lee | Virginia | 51105 | 1230 | 26 |
842298 | 842298 | 2020-12-18 | Lee | Virginia | 51105 | 1213 | 26 |
839053 | 839053 | 2020-12-17 | Lee | Virginia | 51105 | 1197 | 26 |
835807 | 835807 | 2020-12-16 | Lee | Virginia | 51105 | 1185 | 26 |
832561 | 832561 | 2020-12-15 | Lee | Virginia | 51105 | 1173 | 15 |
829314 | 829314 | 2020-12-14 | Lee | Virginia | 51105 | 1168 | 15 |
826068 | 826068 | 2020-12-13 | Lee | Virginia | 51105 | 1141 | 15 |
822821 | 822821 | 2020-12-12 | Lee | Virginia | 51105 | 1121 | 15 |
819575 | 819575 | 2020-12-11 | Lee | Virginia | 51105 | 1103 | 15 |
816329 | 816329 | 2020-12-10 | Lee | Virginia | 51105 | 1094 | 15 |
813083 | 813083 | 2020-12-09 | Lee | Virginia | 51105 | 1066 | 15 |
809839 | 809839 | 2020-12-08 | Lee | Virginia | 51105 | 1051 | 15 |
806594 | 806594 | 2020-12-07 | Lee | Virginia | 51105 | 1041 | 15 |
803349 | 803349 | 2020-12-06 | Lee | Virginia | 51105 | 1029 | 15 |
800104 | 800104 | 2020-12-05 | Lee | Virginia | 51105 | 1012 | 15 |
796859 | 796859 | 2020-12-04 | Lee | Virginia | 51105 | 991 | 15 |
793614 | 793614 | 2020-12-03 | Lee | Virginia | 51105 | 982 | 15 |
790369 | 790369 | 2020-12-02 | Lee | Virginia | 51105 | 971 | 14 |
787124 | 787124 | 2020-12-01 | Lee | Virginia | 51105 | 952 | 14 |
783880 | 783880 | 2020-11-30 | Lee | Virginia | 51105 | 933 | 14 |
780635 | 780635 | 2020-11-29 | Lee | Virginia | 51105 | 920 | 14 |
777389 | 777389 | 2020-11-28 | Lee | Virginia | 51105 | 918 | 14 |
774144 | 774144 | 2020-11-27 | Lee | Virginia | 51105 | 913 | 14 |
770899 | 770899 | 2020-11-26 | Lee | Virginia | 51105 | 898 | 14 |
767653 | 767653 | 2020-11-25 | Lee | Virginia | 51105 | 877 | 13 |
764408 | 764408 | 2020-11-24 | Lee | Virginia | 51105 | 831 | 12 |
761163 | 761163 | 2020-11-23 | Lee | Virginia | 51105 | 828 | 12 |
757918 | 757918 | 2020-11-22 | Lee | Virginia | 51105 | 802 | 12 |
754671 | 754671 | 2020-11-21 | Lee | Virginia | 51105 | 789 | 12 |
751425 | 751425 | 2020-11-20 | Lee | Virginia | 51105 | 783 | 12 |
748179 | 748179 | 2020-11-19 | Lee | Virginia | 51105 | 777 | 11 |
744933 | 744933 | 2020-11-18 | Lee | Virginia | 51105 | 770 | 11 |
741686 | 741686 | 2020-11-17 | Lee | Virginia | 51105 | 754 | 11 |
738439 | 738439 | 2020-11-16 | Lee | Virginia | 51105 | 744 | 11 |
735195 | 735195 | 2020-11-15 | Lee | Virginia | 51105 | 739 | 11 |
731949 | 731949 | 2020-11-14 | Lee | Virginia | 51105 | 723 | 11 |
728704 | 728704 | 2020-11-13 | Lee | Virginia | 51105 | 706 | 11 |
725461 | 725461 | 2020-11-12 | Lee | Virginia | 51105 | 700 | 11 |
722218 | 722218 | 2020-11-11 | Lee | Virginia | 51105 | 690 | 11 |
718975 | 718975 | 2020-11-10 | Lee | Virginia | 51105 | 685 | 11 |
715732 | 715732 | 2020-11-09 | Lee | Virginia | 51105 | 674 | 11 |
712488 | 712488 | 2020-11-08 | Lee | Virginia | 51105 | 671 | 11 |
709244 | 709244 | 2020-11-07 | Lee | Virginia | 51105 | 638 | 11 |
706000 | 706000 | 2020-11-06 | Lee | Virginia | 51105 | 616 | 11 |
702757 | 702757 | 2020-11-05 | Lee | Virginia | 51105 | 610 | 10 |
699514 | 699514 | 2020-11-04 | Lee | Virginia | 51105 | 598 | 10 |
696270 | 696270 | 2020-11-03 | Lee | Virginia | 51105 | 592 | 10 |
693028 | 693028 | 2020-11-02 | Lee | Virginia | 51105 | 589 | 10 |
689784 | 689784 | 2020-11-01 | Lee | Virginia | 51105 | 579 | 10 |
686539 | 686539 | 2020-10-31 | Lee | Virginia | 51105 | 536 | 10 |
683296 | 683296 | 2020-10-30 | Lee | Virginia | 51105 | 516 | 10 |
680053 | 680053 | 2020-10-29 | Lee | Virginia | 51105 | 509 | 10 |
676810 | 676810 | 2020-10-28 | Lee | Virginia | 51105 | 496 | 10 |
673567 | 673567 | 2020-10-27 | Lee | Virginia | 51105 | 479 | 10 |
670325 | 670325 | 2020-10-26 | Lee | Virginia | 51105 | 473 | 9 |
667082 | 667082 | 2020-10-25 | Lee | Virginia | 51105 | 460 | 9 |
663837 | 663837 | 2020-10-24 | Lee | Virginia | 51105 | 437 | 9 |
660593 | 660593 | 2020-10-23 | Lee | Virginia | 51105 | 423 | 9 |
657349 | 657349 | 2020-10-22 | Lee | Virginia | 51105 | 422 | 9 |
654104 | 654104 | 2020-10-21 | Lee | Virginia | 51105 | 413 | 9 |
650859 | 650859 | 2020-10-20 | Lee | Virginia | 51105 | 400 | 9 |
647615 | 647615 | 2020-10-19 | Lee | Virginia | 51105 | 392 | 9 |
644369 | 644369 | 2020-10-18 | Lee | Virginia | 51105 | 392 | 9 |
641121 | 641121 | 2020-10-17 | Lee | Virginia | 51105 | 374 | 9 |
637874 | 637874 | 2020-10-16 | Lee | Virginia | 51105 | 366 | 9 |
634629 | 634629 | 2020-10-15 | Lee | Virginia | 51105 | 359 | 8 |
631384 | 631384 | 2020-10-14 | Lee | Virginia | 51105 | 354 | 8 |
628140 | 628140 | 2020-10-13 | Lee | Virginia | 51105 | 343 | 8 |
624897 | 624897 | 2020-10-12 | Lee | Virginia | 51105 | 331 | 8 |
621654 | 621654 | 2020-10-11 | Lee | Virginia | 51105 | 324 | 8 |
618411 | 618411 | 2020-10-10 | Lee | Virginia | 51105 | 320 | 7 |
615169 | 615169 | 2020-10-09 | Lee | Virginia | 51105 | 315 | 7 |
611928 | 611928 | 2020-10-08 | Lee | Virginia | 51105 | 310 | 7 |
608686 | 608686 | 2020-10-07 | Lee | Virginia | 51105 | 306 | 7 |
605443 | 605443 | 2020-10-06 | Lee | Virginia | 51105 | 306 | 7 |
602201 | 602201 | 2020-10-05 | Lee | Virginia | 51105 | 305 | 7 |
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);