ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
766 rows where fips = 54005 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 |
---|---|---|---|---|---|---|---|
923535 | 923535 | 2021-01-12 | Boone | West Virginia | 54005 | 1228 | 25 |
920290 | 920290 | 2021-01-11 | Boone | West Virginia | 54005 | 1215 | 24 |
917045 | 917045 | 2021-01-10 | Boone | West Virginia | 54005 | 1202 | 24 |
913800 | 913800 | 2021-01-09 | Boone | West Virginia | 54005 | 1190 | 22 |
910555 | 910555 | 2021-01-08 | Boone | West Virginia | 54005 | 1166 | 22 |
907310 | 907310 | 2021-01-07 | Boone | West Virginia | 54005 | 1150 | 22 |
904064 | 904064 | 2021-01-06 | Boone | West Virginia | 54005 | 1137 | 22 |
900819 | 900819 | 2021-01-05 | Boone | West Virginia | 54005 | 1120 | 22 |
897574 | 897574 | 2021-01-04 | Boone | West Virginia | 54005 | 1102 | 22 |
894328 | 894328 | 2021-01-03 | Boone | West Virginia | 54005 | 1098 | 22 |
891082 | 891082 | 2021-01-02 | Boone | West Virginia | 54005 | 1097 | 22 |
887835 | 887835 | 2021-01-01 | Boone | West Virginia | 54005 | 1087 | 22 |
884590 | 884590 | 2020-12-31 | Boone | West Virginia | 54005 | 1067 | 21 |
881345 | 881345 | 2020-12-30 | Boone | West Virginia | 54005 | 1053 | 21 |
878100 | 878100 | 2020-12-29 | Boone | West Virginia | 54005 | 1031 | 20 |
874855 | 874855 | 2020-12-28 | Boone | West Virginia | 54005 | 1019 | 20 |
871610 | 871610 | 2020-12-27 | Boone | West Virginia | 54005 | 1005 | 20 |
868365 | 868365 | 2020-12-26 | Boone | West Virginia | 54005 | 1004 | 20 |
865120 | 865120 | 2020-12-25 | Boone | West Virginia | 54005 | 986 | 20 |
861875 | 861875 | 2020-12-24 | Boone | West Virginia | 54005 | 975 | 19 |
858630 | 858630 | 2020-12-23 | Boone | West Virginia | 54005 | 957 | 19 |
855385 | 855385 | 2020-12-22 | Boone | West Virginia | 54005 | 942 | 19 |
852140 | 852140 | 2020-12-21 | Boone | West Virginia | 54005 | 928 | 19 |
848895 | 848895 | 2020-12-20 | Boone | West Virginia | 54005 | 911 | 19 |
845650 | 845650 | 2020-12-19 | Boone | West Virginia | 54005 | 900 | 20 |
842404 | 842404 | 2020-12-18 | Boone | West Virginia | 54005 | 873 | 18 |
839159 | 839159 | 2020-12-17 | Boone | West Virginia | 54005 | 859 | 17 |
835914 | 835914 | 2020-12-16 | Boone | West Virginia | 54005 | 841 | 17 |
832668 | 832668 | 2020-12-15 | Boone | West Virginia | 54005 | 820 | 17 |
829421 | 829421 | 2020-12-14 | Boone | West Virginia | 54005 | 813 | 18 |
826175 | 826175 | 2020-12-13 | Boone | West Virginia | 54005 | 796 | 18 |
822928 | 822928 | 2020-12-12 | Boone | West Virginia | 54005 | 791 | 18 |
819682 | 819682 | 2020-12-11 | Boone | West Virginia | 54005 | 780 | 17 |
816436 | 816436 | 2020-12-10 | Boone | West Virginia | 54005 | 767 | 17 |
813190 | 813190 | 2020-12-09 | Boone | West Virginia | 54005 | 753 | 16 |
809946 | 809946 | 2020-12-08 | Boone | West Virginia | 54005 | 736 | 16 |
806701 | 806701 | 2020-12-07 | Boone | West Virginia | 54005 | 728 | 15 |
803456 | 803456 | 2020-12-06 | Boone | West Virginia | 54005 | 715 | 15 |
800211 | 800211 | 2020-12-05 | Boone | West Virginia | 54005 | 709 | 15 |
796966 | 796966 | 2020-12-04 | Boone | West Virginia | 54005 | 703 | 15 |
793721 | 793721 | 2020-12-03 | Boone | West Virginia | 54005 | 690 | 15 |
790476 | 790476 | 2020-12-02 | Boone | West Virginia | 54005 | 682 | 14 |
787231 | 787231 | 2020-12-01 | Boone | West Virginia | 54005 | 663 | 14 |
783987 | 783987 | 2020-11-30 | Boone | West Virginia | 54005 | 648 | 13 |
780742 | 780742 | 2020-11-29 | Boone | West Virginia | 54005 | 645 | 13 |
777496 | 777496 | 2020-11-28 | Boone | West Virginia | 54005 | 636 | 13 |
774251 | 774251 | 2020-11-27 | Boone | West Virginia | 54005 | 625 | 13 |
771006 | 771006 | 2020-11-26 | Boone | West Virginia | 54005 | 619 | 13 |
767760 | 767760 | 2020-11-25 | Boone | West Virginia | 54005 | 603 | 13 |
764515 | 764515 | 2020-11-24 | Boone | West Virginia | 54005 | 593 | 13 |
761270 | 761270 | 2020-11-23 | Boone | West Virginia | 54005 | 585 | 13 |
758025 | 758025 | 2020-11-22 | Boone | West Virginia | 54005 | 581 | 13 |
754778 | 754778 | 2020-11-21 | Boone | West Virginia | 54005 | 570 | 13 |
751532 | 751532 | 2020-11-20 | Boone | West Virginia | 54005 | 559 | 13 |
748286 | 748286 | 2020-11-19 | Boone | West Virginia | 54005 | 553 | 12 |
745040 | 745040 | 2020-11-18 | Boone | West Virginia | 54005 | 538 | 12 |
741793 | 741793 | 2020-11-17 | Boone | West Virginia | 54005 | 530 | 12 |
738546 | 738546 | 2020-11-16 | Boone | West Virginia | 54005 | 509 | 10 |
735302 | 735302 | 2020-11-15 | Boone | West Virginia | 54005 | 505 | 10 |
732056 | 732056 | 2020-11-14 | Boone | West Virginia | 54005 | 501 | 10 |
728811 | 728811 | 2020-11-13 | Boone | West Virginia | 54005 | 492 | 10 |
725568 | 725568 | 2020-11-12 | Boone | West Virginia | 54005 | 477 | 10 |
722325 | 722325 | 2020-11-11 | Boone | West Virginia | 54005 | 474 | 10 |
719082 | 719082 | 2020-11-10 | Boone | West Virginia | 54005 | 468 | 10 |
715839 | 715839 | 2020-11-09 | Boone | West Virginia | 54005 | 458 | 8 |
712595 | 712595 | 2020-11-08 | Boone | West Virginia | 54005 | 454 | 6 |
709351 | 709351 | 2020-11-07 | Boone | West Virginia | 54005 | 446 | 6 |
706107 | 706107 | 2020-11-06 | Boone | West Virginia | 54005 | 443 | 3 |
702864 | 702864 | 2020-11-05 | Boone | West Virginia | 54005 | 439 | 3 |
699621 | 699621 | 2020-11-04 | Boone | West Virginia | 54005 | 431 | 3 |
696377 | 696377 | 2020-11-03 | Boone | West Virginia | 54005 | 420 | 3 |
693135 | 693135 | 2020-11-02 | Boone | West Virginia | 54005 | 415 | 3 |
689891 | 689891 | 2020-11-01 | Boone | West Virginia | 54005 | 408 | 3 |
686646 | 686646 | 2020-10-31 | Boone | West Virginia | 54005 | 404 | 3 |
683403 | 683403 | 2020-10-30 | Boone | West Virginia | 54005 | 380 | 3 |
680160 | 680160 | 2020-10-29 | Boone | West Virginia | 54005 | 381 | 3 |
676917 | 676917 | 2020-10-28 | Boone | West Virginia | 54005 | 353 | 3 |
673674 | 673674 | 2020-10-27 | Boone | West Virginia | 54005 | 352 | 3 |
670432 | 670432 | 2020-10-26 | Boone | West Virginia | 54005 | 339 | 3 |
667189 | 667189 | 2020-10-25 | Boone | West Virginia | 54005 | 338 | 3 |
663944 | 663944 | 2020-10-24 | Boone | West Virginia | 54005 | 335 | 3 |
660700 | 660700 | 2020-10-23 | Boone | West Virginia | 54005 | 325 | 3 |
657456 | 657456 | 2020-10-22 | Boone | West Virginia | 54005 | 318 | 3 |
654211 | 654211 | 2020-10-21 | Boone | West Virginia | 54005 | 307 | 3 |
650966 | 650966 | 2020-10-20 | Boone | West Virginia | 54005 | 302 | 3 |
647722 | 647722 | 2020-10-19 | Boone | West Virginia | 54005 | 299 | 3 |
644476 | 644476 | 2020-10-18 | Boone | West Virginia | 54005 | 292 | 3 |
641228 | 641228 | 2020-10-17 | Boone | West Virginia | 54005 | 288 | 3 |
637981 | 637981 | 2020-10-16 | Boone | West Virginia | 54005 | 284 | 3 |
634736 | 634736 | 2020-10-15 | Boone | West Virginia | 54005 | 280 | 3 |
631491 | 631491 | 2020-10-14 | Boone | West Virginia | 54005 | 276 | 3 |
628247 | 628247 | 2020-10-13 | Boone | West Virginia | 54005 | 269 | 3 |
625004 | 625004 | 2020-10-12 | Boone | West Virginia | 54005 | 270 | 3 |
621761 | 621761 | 2020-10-11 | Boone | West Virginia | 54005 | 268 | 2 |
618518 | 618518 | 2020-10-10 | Boone | West Virginia | 54005 | 267 | 2 |
615276 | 615276 | 2020-10-09 | Boone | West Virginia | 54005 | 267 | 2 |
612035 | 612035 | 2020-10-08 | Boone | West Virginia | 54005 | 263 | 2 |
608793 | 608793 | 2020-10-07 | Boone | West Virginia | 54005 | 262 | 2 |
605550 | 605550 | 2020-10-06 | Boone | West Virginia | 54005 | 259 | 2 |
602308 | 602308 | 2020-10-05 | Boone | West Virginia | 54005 | 254 | 2 |
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);