ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
789 rows where county = "York" and state = "Virginia" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
923493 | 923493 | 2021-01-12 | York | Virginia | 51199 | 1886 | 13 |
920248 | 920248 | 2021-01-11 | York | Virginia | 51199 | 1843 | 13 |
917003 | 917003 | 2021-01-10 | York | Virginia | 51199 | 1801 | 13 |
913758 | 913758 | 2021-01-09 | York | Virginia | 51199 | 1757 | 13 |
910513 | 910513 | 2021-01-08 | York | Virginia | 51199 | 1729 | 13 |
907268 | 907268 | 2021-01-07 | York | Virginia | 51199 | 1701 | 13 |
904022 | 904022 | 2021-01-06 | York | Virginia | 51199 | 1661 | 13 |
900777 | 900777 | 2021-01-05 | York | Virginia | 51199 | 1634 | 13 |
897532 | 897532 | 2021-01-04 | York | Virginia | 51199 | 1601 | 13 |
894286 | 894286 | 2021-01-03 | York | Virginia | 51199 | 1566 | 13 |
891040 | 891040 | 2021-01-02 | York | Virginia | 51199 | 1493 | 13 |
887793 | 887793 | 2021-01-01 | York | Virginia | 51199 | 1491 | 13 |
884548 | 884548 | 2020-12-31 | York | Virginia | 51199 | 1472 | 12 |
881303 | 881303 | 2020-12-30 | York | Virginia | 51199 | 1452 | 12 |
878058 | 878058 | 2020-12-29 | York | Virginia | 51199 | 1441 | 11 |
874813 | 874813 | 2020-12-28 | York | Virginia | 51199 | 1397 | 11 |
871568 | 871568 | 2020-12-27 | York | Virginia | 51199 | 1372 | 11 |
868323 | 868323 | 2020-12-26 | York | Virginia | 51199 | 1368 | 11 |
865078 | 865078 | 2020-12-25 | York | Virginia | 51199 | 1367 | 11 |
861833 | 861833 | 2020-12-24 | York | Virginia | 51199 | 1362 | 11 |
858588 | 858588 | 2020-12-23 | York | Virginia | 51199 | 1334 | 11 |
855343 | 855343 | 2020-12-22 | York | Virginia | 51199 | 1306 | 10 |
852098 | 852098 | 2020-12-21 | York | Virginia | 51199 | 1276 | 10 |
848853 | 848853 | 2020-12-20 | York | Virginia | 51199 | 1262 | 10 |
845608 | 845608 | 2020-12-19 | York | Virginia | 51199 | 1241 | 10 |
842362 | 842362 | 2020-12-18 | York | Virginia | 51199 | 1213 | 10 |
839117 | 839117 | 2020-12-17 | York | Virginia | 51199 | 1181 | 9 |
835871 | 835871 | 2020-12-16 | York | Virginia | 51199 | 1159 | 9 |
832625 | 832625 | 2020-12-15 | York | Virginia | 51199 | 1129 | 9 |
829378 | 829378 | 2020-12-14 | York | Virginia | 51199 | 1105 | 9 |
826132 | 826132 | 2020-12-13 | York | Virginia | 51199 | 1089 | 9 |
822885 | 822885 | 2020-12-12 | York | Virginia | 51199 | 1069 | 9 |
819639 | 819639 | 2020-12-11 | York | Virginia | 51199 | 1046 | 9 |
816393 | 816393 | 2020-12-10 | York | Virginia | 51199 | 1038 | 9 |
813147 | 813147 | 2020-12-09 | York | Virginia | 51199 | 1023 | 9 |
809903 | 809903 | 2020-12-08 | York | Virginia | 51199 | 1012 | 9 |
806658 | 806658 | 2020-12-07 | York | Virginia | 51199 | 1007 | 9 |
803413 | 803413 | 2020-12-06 | York | Virginia | 51199 | 992 | 9 |
800168 | 800168 | 2020-12-05 | York | Virginia | 51199 | 975 | 9 |
796923 | 796923 | 2020-12-04 | York | Virginia | 51199 | 968 | 9 |
793678 | 793678 | 2020-12-03 | York | Virginia | 51199 | 957 | 9 |
790433 | 790433 | 2020-12-02 | York | Virginia | 51199 | 950 | 9 |
787188 | 787188 | 2020-12-01 | York | Virginia | 51199 | 929 | 9 |
783944 | 783944 | 2020-11-30 | York | Virginia | 51199 | 921 | 9 |
780699 | 780699 | 2020-11-29 | York | Virginia | 51199 | 908 | 9 |
777453 | 777453 | 2020-11-28 | York | Virginia | 51199 | 889 | 9 |
774208 | 774208 | 2020-11-27 | York | Virginia | 51199 | 877 | 9 |
770963 | 770963 | 2020-11-26 | York | Virginia | 51199 | 875 | 9 |
767717 | 767717 | 2020-11-25 | York | Virginia | 51199 | 867 | 9 |
764472 | 764472 | 2020-11-24 | York | Virginia | 51199 | 859 | 9 |
761227 | 761227 | 2020-11-23 | York | Virginia | 51199 | 848 | 9 |
757982 | 757982 | 2020-11-22 | York | Virginia | 51199 | 825 | 9 |
754735 | 754735 | 2020-11-21 | York | Virginia | 51199 | 817 | 9 |
751489 | 751489 | 2020-11-20 | York | Virginia | 51199 | 806 | 9 |
748243 | 748243 | 2020-11-19 | York | Virginia | 51199 | 783 | 9 |
744997 | 744997 | 2020-11-18 | York | Virginia | 51199 | 775 | 9 |
741750 | 741750 | 2020-11-17 | York | Virginia | 51199 | 767 | 9 |
738503 | 738503 | 2020-11-16 | York | Virginia | 51199 | 759 | 9 |
735259 | 735259 | 2020-11-15 | York | Virginia | 51199 | 745 | 9 |
732013 | 732013 | 2020-11-14 | York | Virginia | 51199 | 735 | 9 |
728768 | 728768 | 2020-11-13 | York | Virginia | 51199 | 724 | 9 |
725525 | 725525 | 2020-11-12 | York | Virginia | 51199 | 719 | 9 |
722282 | 722282 | 2020-11-11 | York | Virginia | 51199 | 718 | 9 |
719039 | 719039 | 2020-11-10 | York | Virginia | 51199 | 713 | 9 |
715796 | 715796 | 2020-11-09 | York | Virginia | 51199 | 710 | 9 |
712552 | 712552 | 2020-11-08 | York | Virginia | 51199 | 707 | 9 |
709308 | 709308 | 2020-11-07 | York | Virginia | 51199 | 697 | 9 |
706064 | 706064 | 2020-11-06 | York | Virginia | 51199 | 686 | 9 |
702821 | 702821 | 2020-11-05 | York | Virginia | 51199 | 670 | 9 |
699578 | 699578 | 2020-11-04 | York | Virginia | 51199 | 668 | 9 |
696334 | 696334 | 2020-11-03 | York | Virginia | 51199 | 665 | 9 |
693092 | 693092 | 2020-11-02 | York | Virginia | 51199 | 661 | 9 |
689848 | 689848 | 2020-11-01 | York | Virginia | 51199 | 658 | 9 |
686603 | 686603 | 2020-10-31 | York | Virginia | 51199 | 658 | 9 |
683360 | 683360 | 2020-10-30 | York | Virginia | 51199 | 650 | 9 |
680117 | 680117 | 2020-10-29 | York | Virginia | 51199 | 646 | 9 |
676874 | 676874 | 2020-10-28 | York | Virginia | 51199 | 644 | 9 |
673631 | 673631 | 2020-10-27 | York | Virginia | 51199 | 640 | 9 |
670389 | 670389 | 2020-10-26 | York | Virginia | 51199 | 637 | 9 |
667146 | 667146 | 2020-10-25 | York | Virginia | 51199 | 637 | 9 |
663901 | 663901 | 2020-10-24 | York | Virginia | 51199 | 629 | 9 |
660657 | 660657 | 2020-10-23 | York | Virginia | 51199 | 626 | 9 |
657413 | 657413 | 2020-10-22 | York | Virginia | 51199 | 626 | 9 |
654168 | 654168 | 2020-10-21 | York | Virginia | 51199 | 625 | 9 |
650923 | 650923 | 2020-10-20 | York | Virginia | 51199 | 620 | 9 |
647679 | 647679 | 2020-10-19 | York | Virginia | 51199 | 617 | 9 |
644433 | 644433 | 2020-10-18 | York | Virginia | 51199 | 616 | 9 |
641185 | 641185 | 2020-10-17 | York | Virginia | 51199 | 616 | 9 |
637938 | 637938 | 2020-10-16 | York | Virginia | 51199 | 612 | 9 |
634693 | 634693 | 2020-10-15 | York | Virginia | 51199 | 603 | 9 |
631448 | 631448 | 2020-10-14 | York | Virginia | 51199 | 595 | 9 |
628204 | 628204 | 2020-10-13 | York | Virginia | 51199 | 592 | 9 |
624961 | 624961 | 2020-10-12 | York | Virginia | 51199 | 588 | 9 |
621718 | 621718 | 2020-10-11 | York | Virginia | 51199 | 587 | 9 |
618475 | 618475 | 2020-10-10 | York | Virginia | 51199 | 584 | 9 |
615233 | 615233 | 2020-10-09 | York | Virginia | 51199 | 580 | 9 |
611992 | 611992 | 2020-10-08 | York | Virginia | 51199 | 570 | 9 |
608750 | 608750 | 2020-10-07 | York | Virginia | 51199 | 564 | 9 |
605507 | 605507 | 2020-10-06 | York | Virginia | 51199 | 566 | 8 |
602265 | 602265 | 2020-10-05 | York | Virginia | 51199 | 564 | 8 |
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);