ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
781 rows where county = "Preston" and state = "West Virginia" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
923571 | 923571 | 2021-01-12 | Preston | West Virginia | 54077 | 2043 | 34 |
920326 | 920326 | 2021-01-11 | Preston | West Virginia | 54077 | 2024 | 34 |
917081 | 917081 | 2021-01-10 | Preston | West Virginia | 54077 | 1992 | 34 |
913836 | 913836 | 2021-01-09 | Preston | West Virginia | 54077 | 1970 | 34 |
910591 | 910591 | 2021-01-08 | Preston | West Virginia | 54077 | 1932 | 32 |
907346 | 907346 | 2021-01-07 | Preston | West Virginia | 54077 | 1882 | 31 |
904100 | 904100 | 2021-01-06 | Preston | West Virginia | 54077 | 1870 | 31 |
900855 | 900855 | 2021-01-05 | Preston | West Virginia | 54077 | 1839 | 31 |
897610 | 897610 | 2021-01-04 | Preston | West Virginia | 54077 | 1805 | 31 |
894364 | 894364 | 2021-01-03 | Preston | West Virginia | 54077 | 1773 | 31 |
891118 | 891118 | 2021-01-02 | Preston | West Virginia | 54077 | 1719 | 31 |
887871 | 887871 | 2021-01-01 | Preston | West Virginia | 54077 | 1691 | 31 |
884626 | 884626 | 2020-12-31 | Preston | West Virginia | 54077 | 1649 | 30 |
881381 | 881381 | 2020-12-30 | Preston | West Virginia | 54077 | 1635 | 30 |
878136 | 878136 | 2020-12-29 | Preston | West Virginia | 54077 | 1612 | 28 |
874891 | 874891 | 2020-12-28 | Preston | West Virginia | 54077 | 1586 | 27 |
871646 | 871646 | 2020-12-27 | Preston | West Virginia | 54077 | 1564 | 27 |
868401 | 868401 | 2020-12-26 | Preston | West Virginia | 54077 | 1539 | 27 |
865156 | 865156 | 2020-12-25 | Preston | West Virginia | 54077 | 1523 | 26 |
861911 | 861911 | 2020-12-24 | Preston | West Virginia | 54077 | 1450 | 25 |
858666 | 858666 | 2020-12-23 | Preston | West Virginia | 54077 | 1407 | 25 |
855421 | 855421 | 2020-12-22 | Preston | West Virginia | 54077 | 1352 | 25 |
852176 | 852176 | 2020-12-21 | Preston | West Virginia | 54077 | 1320 | 19 |
848931 | 848931 | 2020-12-20 | Preston | West Virginia | 54077 | 1296 | 19 |
845686 | 845686 | 2020-12-19 | Preston | West Virginia | 54077 | 1259 | 19 |
842440 | 842440 | 2020-12-18 | Preston | West Virginia | 54077 | 1237 | 19 |
839195 | 839195 | 2020-12-17 | Preston | West Virginia | 54077 | 1188 | 19 |
835950 | 835950 | 2020-12-16 | Preston | West Virginia | 54077 | 1147 | 18 |
832704 | 832704 | 2020-12-15 | Preston | West Virginia | 54077 | 1111 | 18 |
829457 | 829457 | 2020-12-14 | Preston | West Virginia | 54077 | 1081 | 18 |
826211 | 826211 | 2020-12-13 | Preston | West Virginia | 54077 | 1051 | 17 |
822964 | 822964 | 2020-12-12 | Preston | West Virginia | 54077 | 1016 | 17 |
819718 | 819718 | 2020-12-11 | Preston | West Virginia | 54077 | 962 | 17 |
816472 | 816472 | 2020-12-10 | Preston | West Virginia | 54077 | 940 | 16 |
813226 | 813226 | 2020-12-09 | Preston | West Virginia | 54077 | 903 | 15 |
809982 | 809982 | 2020-12-08 | Preston | West Virginia | 54077 | 871 | 15 |
806737 | 806737 | 2020-12-07 | Preston | West Virginia | 54077 | 845 | 15 |
803492 | 803492 | 2020-12-06 | Preston | West Virginia | 54077 | 823 | 15 |
800247 | 800247 | 2020-12-05 | Preston | West Virginia | 54077 | 793 | 14 |
797002 | 797002 | 2020-12-04 | Preston | West Virginia | 54077 | 751 | 12 |
793757 | 793757 | 2020-12-03 | Preston | West Virginia | 54077 | 706 | 12 |
790512 | 790512 | 2020-12-02 | Preston | West Virginia | 54077 | 686 | 12 |
787267 | 787267 | 2020-12-01 | Preston | West Virginia | 54077 | 664 | 9 |
784023 | 784023 | 2020-11-30 | Preston | West Virginia | 54077 | 652 | 9 |
780778 | 780778 | 2020-11-29 | Preston | West Virginia | 54077 | 620 | 9 |
777532 | 777532 | 2020-11-28 | Preston | West Virginia | 54077 | 593 | 9 |
774287 | 774287 | 2020-11-27 | Preston | West Virginia | 54077 | 552 | 7 |
771042 | 771042 | 2020-11-26 | Preston | West Virginia | 54077 | 541 | 7 |
767796 | 767796 | 2020-11-25 | Preston | West Virginia | 54077 | 505 | 6 |
764551 | 764551 | 2020-11-24 | Preston | West Virginia | 54077 | 479 | 6 |
761306 | 761306 | 2020-11-23 | Preston | West Virginia | 54077 | 472 | 6 |
758061 | 758061 | 2020-11-22 | Preston | West Virginia | 54077 | 466 | 6 |
754814 | 754814 | 2020-11-21 | Preston | West Virginia | 54077 | 432 | 6 |
751568 | 751568 | 2020-11-20 | Preston | West Virginia | 54077 | 420 | 6 |
748322 | 748322 | 2020-11-19 | Preston | West Virginia | 54077 | 405 | 6 |
745076 | 745076 | 2020-11-18 | Preston | West Virginia | 54077 | 376 | 6 |
741829 | 741829 | 2020-11-17 | Preston | West Virginia | 54077 | 364 | 6 |
738582 | 738582 | 2020-11-16 | Preston | West Virginia | 54077 | 350 | 6 |
735338 | 735338 | 2020-11-15 | Preston | West Virginia | 54077 | 337 | 6 |
732092 | 732092 | 2020-11-14 | Preston | West Virginia | 54077 | 321 | 6 |
728847 | 728847 | 2020-11-13 | Preston | West Virginia | 54077 | 301 | 6 |
725604 | 725604 | 2020-11-12 | Preston | West Virginia | 54077 | 293 | 7 |
722361 | 722361 | 2020-11-11 | Preston | West Virginia | 54077 | 287 | 7 |
719118 | 719118 | 2020-11-10 | Preston | West Virginia | 54077 | 280 | 7 |
715875 | 715875 | 2020-11-09 | Preston | West Virginia | 54077 | 279 | 6 |
712631 | 712631 | 2020-11-08 | Preston | West Virginia | 54077 | 272 | 5 |
709387 | 709387 | 2020-11-07 | Preston | West Virginia | 54077 | 264 | 5 |
706143 | 706143 | 2020-11-06 | Preston | West Virginia | 54077 | 252 | 4 |
702900 | 702900 | 2020-11-05 | Preston | West Virginia | 54077 | 249 | 4 |
699657 | 699657 | 2020-11-04 | Preston | West Virginia | 54077 | 238 | 4 |
696413 | 696413 | 2020-11-03 | Preston | West Virginia | 54077 | 236 | 4 |
693171 | 693171 | 2020-11-02 | Preston | West Virginia | 54077 | 227 | 4 |
689927 | 689927 | 2020-11-01 | Preston | West Virginia | 54077 | 225 | 4 |
686682 | 686682 | 2020-10-31 | Preston | West Virginia | 54077 | 214 | 4 |
683439 | 683439 | 2020-10-30 | Preston | West Virginia | 54077 | 208 | 4 |
680196 | 680196 | 2020-10-29 | Preston | West Virginia | 54077 | 200 | 4 |
676953 | 676953 | 2020-10-28 | Preston | West Virginia | 54077 | 199 | 4 |
673710 | 673710 | 2020-10-27 | Preston | West Virginia | 54077 | 199 | 4 |
670468 | 670468 | 2020-10-26 | Preston | West Virginia | 54077 | 199 | 4 |
667225 | 667225 | 2020-10-25 | Preston | West Virginia | 54077 | 194 | 4 |
663980 | 663980 | 2020-10-24 | Preston | West Virginia | 54077 | 194 | 4 |
660736 | 660736 | 2020-10-23 | Preston | West Virginia | 54077 | 192 | 4 |
657492 | 657492 | 2020-10-22 | Preston | West Virginia | 54077 | 186 | 4 |
654247 | 654247 | 2020-10-21 | Preston | West Virginia | 54077 | 181 | 4 |
651002 | 651002 | 2020-10-20 | Preston | West Virginia | 54077 | 179 | 4 |
647758 | 647758 | 2020-10-19 | Preston | West Virginia | 54077 | 176 | 4 |
644512 | 644512 | 2020-10-18 | Preston | West Virginia | 54077 | 174 | 4 |
641264 | 641264 | 2020-10-17 | Preston | West Virginia | 54077 | 174 | 4 |
638017 | 638017 | 2020-10-16 | Preston | West Virginia | 54077 | 174 | 4 |
634772 | 634772 | 2020-10-15 | Preston | West Virginia | 54077 | 172 | 4 |
631527 | 631527 | 2020-10-14 | Preston | West Virginia | 54077 | 171 | 4 |
628283 | 628283 | 2020-10-13 | Preston | West Virginia | 54077 | 171 | 4 |
625040 | 625040 | 2020-10-12 | Preston | West Virginia | 54077 | 171 | 4 |
621797 | 621797 | 2020-10-11 | Preston | West Virginia | 54077 | 171 | 4 |
618554 | 618554 | 2020-10-10 | Preston | West Virginia | 54077 | 170 | 4 |
615312 | 615312 | 2020-10-09 | Preston | West Virginia | 54077 | 168 | 4 |
612071 | 612071 | 2020-10-08 | Preston | West Virginia | 54077 | 165 | 4 |
608829 | 608829 | 2020-10-07 | Preston | West Virginia | 54077 | 162 | 4 |
605586 | 605586 | 2020-10-06 | Preston | West Virginia | 54077 | 161 | 4 |
602344 | 602344 | 2020-10-05 | Preston | West Virginia | 54077 | 161 | 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);