ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
780 rows where fips = 54081 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 |
---|---|---|---|---|---|---|---|
933309 | 933309 | 2021-01-15 | Raleigh | West Virginia | 54081 | 3505 | 37 |
930064 | 930064 | 2021-01-14 | Raleigh | West Virginia | 54081 | 3426 | 36 |
926819 | 926819 | 2021-01-13 | Raleigh | West Virginia | 54081 | 3400 | 34 |
923573 | 923573 | 2021-01-12 | Raleigh | West Virginia | 54081 | 3356 | 33 |
920328 | 920328 | 2021-01-11 | Raleigh | West Virginia | 54081 | 3323 | 33 |
917083 | 917083 | 2021-01-10 | Raleigh | West Virginia | 54081 | 3261 | 33 |
913838 | 913838 | 2021-01-09 | Raleigh | West Virginia | 54081 | 3209 | 32 |
910593 | 910593 | 2021-01-08 | Raleigh | West Virginia | 54081 | 3153 | 32 |
907348 | 907348 | 2021-01-07 | Raleigh | West Virginia | 54081 | 3048 | 31 |
904102 | 904102 | 2021-01-06 | Raleigh | West Virginia | 54081 | 3003 | 31 |
900857 | 900857 | 2021-01-05 | Raleigh | West Virginia | 54081 | 2958 | 30 |
897612 | 897612 | 2021-01-04 | Raleigh | West Virginia | 54081 | 2914 | 30 |
894366 | 894366 | 2021-01-03 | Raleigh | West Virginia | 54081 | 2891 | 30 |
891120 | 891120 | 2021-01-02 | Raleigh | West Virginia | 54081 | 2833 | 30 |
887873 | 887873 | 2021-01-01 | Raleigh | West Virginia | 54081 | 2761 | 29 |
884628 | 884628 | 2020-12-31 | Raleigh | West Virginia | 54081 | 2670 | 29 |
881383 | 881383 | 2020-12-30 | Raleigh | West Virginia | 54081 | 2655 | 29 |
878138 | 878138 | 2020-12-29 | Raleigh | West Virginia | 54081 | 2609 | 28 |
874893 | 874893 | 2020-12-28 | Raleigh | West Virginia | 54081 | 2562 | 28 |
871648 | 871648 | 2020-12-27 | Raleigh | West Virginia | 54081 | 2532 | 28 |
868403 | 868403 | 2020-12-26 | Raleigh | West Virginia | 54081 | 2527 | 28 |
865158 | 865158 | 2020-12-25 | Raleigh | West Virginia | 54081 | 2497 | 28 |
861913 | 861913 | 2020-12-24 | Raleigh | West Virginia | 54081 | 2454 | 27 |
858668 | 858668 | 2020-12-23 | Raleigh | West Virginia | 54081 | 2434 | 27 |
855423 | 855423 | 2020-12-22 | Raleigh | West Virginia | 54081 | 2408 | 26 |
852178 | 852178 | 2020-12-21 | Raleigh | West Virginia | 54081 | 2360 | 25 |
848933 | 848933 | 2020-12-20 | Raleigh | West Virginia | 54081 | 2327 | 25 |
845688 | 845688 | 2020-12-19 | Raleigh | West Virginia | 54081 | 2292 | 25 |
842442 | 842442 | 2020-12-18 | Raleigh | West Virginia | 54081 | 2236 | 24 |
839197 | 839197 | 2020-12-17 | Raleigh | West Virginia | 54081 | 2212 | 23 |
835952 | 835952 | 2020-12-16 | Raleigh | West Virginia | 54081 | 2166 | 20 |
832706 | 832706 | 2020-12-15 | Raleigh | West Virginia | 54081 | 2104 | 20 |
829459 | 829459 | 2020-12-14 | Raleigh | West Virginia | 54081 | 2073 | 20 |
826213 | 826213 | 2020-12-13 | Raleigh | West Virginia | 54081 | 2026 | 19 |
822966 | 822966 | 2020-12-12 | Raleigh | West Virginia | 54081 | 1995 | 19 |
819720 | 819720 | 2020-12-11 | Raleigh | West Virginia | 54081 | 1954 | 19 |
816474 | 816474 | 2020-12-10 | Raleigh | West Virginia | 54081 | 1946 | 19 |
813228 | 813228 | 2020-12-09 | Raleigh | West Virginia | 54081 | 1894 | 18 |
809984 | 809984 | 2020-12-08 | Raleigh | West Virginia | 54081 | 1832 | 18 |
806739 | 806739 | 2020-12-07 | Raleigh | West Virginia | 54081 | 1805 | 17 |
803494 | 803494 | 2020-12-06 | Raleigh | West Virginia | 54081 | 1781 | 17 |
800249 | 800249 | 2020-12-05 | Raleigh | West Virginia | 54081 | 1759 | 17 |
797004 | 797004 | 2020-12-04 | Raleigh | West Virginia | 54081 | 1742 | 17 |
793759 | 793759 | 2020-12-03 | Raleigh | West Virginia | 54081 | 1703 | 17 |
790514 | 790514 | 2020-12-02 | Raleigh | West Virginia | 54081 | 1674 | 17 |
787269 | 787269 | 2020-12-01 | Raleigh | West Virginia | 54081 | 1644 | 17 |
784025 | 784025 | 2020-11-30 | Raleigh | West Virginia | 54081 | 1613 | 16 |
780780 | 780780 | 2020-11-29 | Raleigh | West Virginia | 54081 | 1583 | 16 |
777534 | 777534 | 2020-11-28 | Raleigh | West Virginia | 54081 | 1538 | 16 |
774289 | 774289 | 2020-11-27 | Raleigh | West Virginia | 54081 | 1513 | 16 |
771044 | 771044 | 2020-11-26 | Raleigh | West Virginia | 54081 | 1492 | 16 |
767798 | 767798 | 2020-11-25 | Raleigh | West Virginia | 54081 | 1465 | 15 |
764553 | 764553 | 2020-11-24 | Raleigh | West Virginia | 54081 | 1441 | 15 |
761308 | 761308 | 2020-11-23 | Raleigh | West Virginia | 54081 | 1415 | 15 |
758063 | 758063 | 2020-11-22 | Raleigh | West Virginia | 54081 | 1380 | 15 |
754816 | 754816 | 2020-11-21 | Raleigh | West Virginia | 54081 | 1359 | 15 |
751570 | 751570 | 2020-11-20 | Raleigh | West Virginia | 54081 | 1333 | 15 |
748324 | 748324 | 2020-11-19 | Raleigh | West Virginia | 54081 | 1301 | 15 |
745078 | 745078 | 2020-11-18 | Raleigh | West Virginia | 54081 | 1165 | 15 |
741831 | 741831 | 2020-11-17 | Raleigh | West Virginia | 54081 | 1148 | 15 |
738584 | 738584 | 2020-11-16 | Raleigh | West Virginia | 54081 | 1132 | 15 |
735340 | 735340 | 2020-11-15 | Raleigh | West Virginia | 54081 | 1110 | 15 |
732094 | 732094 | 2020-11-14 | Raleigh | West Virginia | 54081 | 1092 | 15 |
728849 | 728849 | 2020-11-13 | Raleigh | West Virginia | 54081 | 1074 | 15 |
725606 | 725606 | 2020-11-12 | Raleigh | West Virginia | 54081 | 1049 | 15 |
722363 | 722363 | 2020-11-11 | Raleigh | West Virginia | 54081 | 1016 | 15 |
719120 | 719120 | 2020-11-10 | Raleigh | West Virginia | 54081 | 1000 | 14 |
715877 | 715877 | 2020-11-09 | Raleigh | West Virginia | 54081 | 993 | 13 |
712633 | 712633 | 2020-11-08 | Raleigh | West Virginia | 54081 | 978 | 11 |
709389 | 709389 | 2020-11-07 | Raleigh | West Virginia | 54081 | 951 | 11 |
706145 | 706145 | 2020-11-06 | Raleigh | West Virginia | 54081 | 927 | 10 |
702902 | 702902 | 2020-11-05 | Raleigh | West Virginia | 54081 | 916 | 10 |
699659 | 699659 | 2020-11-04 | Raleigh | West Virginia | 54081 | 899 | 10 |
696415 | 696415 | 2020-11-03 | Raleigh | West Virginia | 54081 | 889 | 10 |
693173 | 693173 | 2020-11-02 | Raleigh | West Virginia | 54081 | 880 | 10 |
689929 | 689929 | 2020-11-01 | Raleigh | West Virginia | 54081 | 866 | 10 |
686684 | 686684 | 2020-10-31 | Raleigh | West Virginia | 54081 | 854 | 9 |
683441 | 683441 | 2020-10-30 | Raleigh | West Virginia | 54081 | 834 | 9 |
680198 | 680198 | 2020-10-29 | Raleigh | West Virginia | 54081 | 825 | 9 |
676955 | 676955 | 2020-10-28 | Raleigh | West Virginia | 54081 | 798 | 9 |
673712 | 673712 | 2020-10-27 | Raleigh | West Virginia | 54081 | 780 | 9 |
670470 | 670470 | 2020-10-26 | Raleigh | West Virginia | 54081 | 761 | 8 |
667227 | 667227 | 2020-10-25 | Raleigh | West Virginia | 54081 | 741 | 8 |
663982 | 663982 | 2020-10-24 | Raleigh | West Virginia | 54081 | 723 | 8 |
660738 | 660738 | 2020-10-23 | Raleigh | West Virginia | 54081 | 712 | 8 |
657494 | 657494 | 2020-10-22 | Raleigh | West Virginia | 54081 | 702 | 8 |
654249 | 654249 | 2020-10-21 | Raleigh | West Virginia | 54081 | 681 | 8 |
651004 | 651004 | 2020-10-20 | Raleigh | West Virginia | 54081 | 674 | 8 |
647760 | 647760 | 2020-10-19 | Raleigh | West Virginia | 54081 | 665 | 8 |
644514 | 644514 | 2020-10-18 | Raleigh | West Virginia | 54081 | 660 | 8 |
641266 | 641266 | 2020-10-17 | Raleigh | West Virginia | 54081 | 643 | 8 |
638019 | 638019 | 2020-10-16 | Raleigh | West Virginia | 54081 | 638 | 8 |
634774 | 634774 | 2020-10-15 | Raleigh | West Virginia | 54081 | 629 | 8 |
631529 | 631529 | 2020-10-14 | Raleigh | West Virginia | 54081 | 623 | 8 |
628285 | 628285 | 2020-10-13 | Raleigh | West Virginia | 54081 | 616 | 8 |
625042 | 625042 | 2020-10-12 | Raleigh | West Virginia | 54081 | 612 | 8 |
621799 | 621799 | 2020-10-11 | Raleigh | West Virginia | 54081 | 608 | 8 |
618556 | 618556 | 2020-10-10 | Raleigh | West Virginia | 54081 | 604 | 8 |
615314 | 615314 | 2020-10-09 | Raleigh | West Virginia | 54081 | 596 | 8 |
612073 | 612073 | 2020-10-08 | Raleigh | West Virginia | 54081 | 581 | 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);