ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
778 rows where fips = 54025 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 |
---|---|---|---|---|---|---|---|
933281 | 933281 | 2021-01-15 | Greenbrier | West Virginia | 54025 | 1978 | 45 |
930036 | 930036 | 2021-01-14 | Greenbrier | West Virginia | 54025 | 1961 | 43 |
926791 | 926791 | 2021-01-13 | Greenbrier | West Virginia | 54025 | 1936 | 43 |
923545 | 923545 | 2021-01-12 | Greenbrier | West Virginia | 54025 | 1914 | 43 |
920300 | 920300 | 2021-01-11 | Greenbrier | West Virginia | 54025 | 1877 | 43 |
917055 | 917055 | 2021-01-10 | Greenbrier | West Virginia | 54025 | 1823 | 43 |
913810 | 913810 | 2021-01-09 | Greenbrier | West Virginia | 54025 | 1790 | 43 |
910565 | 910565 | 2021-01-08 | Greenbrier | West Virginia | 54025 | 1761 | 43 |
907320 | 907320 | 2021-01-07 | Greenbrier | West Virginia | 54025 | 1711 | 41 |
904074 | 904074 | 2021-01-06 | Greenbrier | West Virginia | 54025 | 1677 | 40 |
900829 | 900829 | 2021-01-05 | Greenbrier | West Virginia | 54025 | 1641 | 40 |
897584 | 897584 | 2021-01-04 | Greenbrier | West Virginia | 54025 | 1619 | 36 |
894338 | 894338 | 2021-01-03 | Greenbrier | West Virginia | 54025 | 1612 | 35 |
891092 | 891092 | 2021-01-02 | Greenbrier | West Virginia | 54025 | 1564 | 35 |
887845 | 887845 | 2021-01-01 | Greenbrier | West Virginia | 54025 | 1521 | 35 |
884600 | 884600 | 2020-12-31 | Greenbrier | West Virginia | 54025 | 1469 | 35 |
881355 | 881355 | 2020-12-30 | Greenbrier | West Virginia | 54025 | 1436 | 32 |
878110 | 878110 | 2020-12-29 | Greenbrier | West Virginia | 54025 | 1391 | 31 |
874865 | 874865 | 2020-12-28 | Greenbrier | West Virginia | 54025 | 1368 | 28 |
871620 | 871620 | 2020-12-27 | Greenbrier | West Virginia | 54025 | 1349 | 27 |
868375 | 868375 | 2020-12-26 | Greenbrier | West Virginia | 54025 | 1335 | 27 |
865130 | 865130 | 2020-12-25 | Greenbrier | West Virginia | 54025 | 1294 | 27 |
861885 | 861885 | 2020-12-24 | Greenbrier | West Virginia | 54025 | 1256 | 26 |
858640 | 858640 | 2020-12-23 | Greenbrier | West Virginia | 54025 | 1221 | 24 |
855395 | 855395 | 2020-12-22 | Greenbrier | West Virginia | 54025 | 1194 | 23 |
852150 | 852150 | 2020-12-21 | Greenbrier | West Virginia | 54025 | 1155 | 22 |
848905 | 848905 | 2020-12-20 | Greenbrier | West Virginia | 54025 | 1131 | 22 |
845660 | 845660 | 2020-12-19 | Greenbrier | West Virginia | 54025 | 1087 | 22 |
842414 | 842414 | 2020-12-18 | Greenbrier | West Virginia | 54025 | 1066 | 20 |
839169 | 839169 | 2020-12-17 | Greenbrier | West Virginia | 54025 | 1025 | 18 |
835924 | 835924 | 2020-12-16 | Greenbrier | West Virginia | 54025 | 963 | 18 |
832678 | 832678 | 2020-12-15 | Greenbrier | West Virginia | 54025 | 945 | 17 |
829431 | 829431 | 2020-12-14 | Greenbrier | West Virginia | 54025 | 924 | 16 |
826185 | 826185 | 2020-12-13 | Greenbrier | West Virginia | 54025 | 872 | 16 |
822938 | 822938 | 2020-12-12 | Greenbrier | West Virginia | 54025 | 836 | 16 |
819692 | 819692 | 2020-12-11 | Greenbrier | West Virginia | 54025 | 792 | 14 |
816446 | 816446 | 2020-12-10 | Greenbrier | West Virginia | 54025 | 772 | 14 |
813200 | 813200 | 2020-12-09 | Greenbrier | West Virginia | 54025 | 721 | 12 |
809956 | 809956 | 2020-12-08 | Greenbrier | West Virginia | 54025 | 707 | 12 |
806711 | 806711 | 2020-12-07 | Greenbrier | West Virginia | 54025 | 681 | 9 |
803466 | 803466 | 2020-12-06 | Greenbrier | West Virginia | 54025 | 659 | 9 |
800221 | 800221 | 2020-12-05 | Greenbrier | West Virginia | 54025 | 625 | 8 |
796976 | 796976 | 2020-12-04 | Greenbrier | West Virginia | 54025 | 592 | 10 |
793731 | 793731 | 2020-12-03 | Greenbrier | West Virginia | 54025 | 571 | 9 |
790486 | 790486 | 2020-12-02 | Greenbrier | West Virginia | 54025 | 552 | 8 |
787241 | 787241 | 2020-12-01 | Greenbrier | West Virginia | 54025 | 534 | 7 |
783997 | 783997 | 2020-11-30 | Greenbrier | West Virginia | 54025 | 516 | 7 |
780752 | 780752 | 2020-11-29 | Greenbrier | West Virginia | 54025 | 499 | 7 |
777506 | 777506 | 2020-11-28 | Greenbrier | West Virginia | 54025 | 475 | 6 |
774261 | 774261 | 2020-11-27 | Greenbrier | West Virginia | 54025 | 462 | 6 |
771016 | 771016 | 2020-11-26 | Greenbrier | West Virginia | 54025 | 432 | 7 |
767770 | 767770 | 2020-11-25 | Greenbrier | West Virginia | 54025 | 414 | 7 |
764525 | 764525 | 2020-11-24 | Greenbrier | West Virginia | 54025 | 412 | 6 |
761280 | 761280 | 2020-11-23 | Greenbrier | West Virginia | 54025 | 396 | 6 |
758035 | 758035 | 2020-11-22 | Greenbrier | West Virginia | 54025 | 381 | 6 |
754788 | 754788 | 2020-11-21 | Greenbrier | West Virginia | 54025 | 373 | 6 |
751542 | 751542 | 2020-11-20 | Greenbrier | West Virginia | 54025 | 361 | 6 |
748296 | 748296 | 2020-11-19 | Greenbrier | West Virginia | 54025 | 344 | 6 |
745050 | 745050 | 2020-11-18 | Greenbrier | West Virginia | 54025 | 336 | 6 |
741803 | 741803 | 2020-11-17 | Greenbrier | West Virginia | 54025 | 330 | 6 |
738556 | 738556 | 2020-11-16 | Greenbrier | West Virginia | 54025 | 319 | 6 |
735312 | 735312 | 2020-11-15 | Greenbrier | West Virginia | 54025 | 308 | 6 |
732066 | 732066 | 2020-11-14 | Greenbrier | West Virginia | 54025 | 298 | 6 |
728821 | 728821 | 2020-11-13 | Greenbrier | West Virginia | 54025 | 282 | 5 |
725578 | 725578 | 2020-11-12 | Greenbrier | West Virginia | 54025 | 278 | 5 |
722335 | 722335 | 2020-11-11 | Greenbrier | West Virginia | 54025 | 272 | 5 |
719092 | 719092 | 2020-11-10 | Greenbrier | West Virginia | 54025 | 264 | 5 |
715849 | 715849 | 2020-11-09 | Greenbrier | West Virginia | 54025 | 258 | 5 |
712605 | 712605 | 2020-11-08 | Greenbrier | West Virginia | 54025 | 252 | 5 |
709361 | 709361 | 2020-11-07 | Greenbrier | West Virginia | 54025 | 246 | 5 |
706117 | 706117 | 2020-11-06 | Greenbrier | West Virginia | 54025 | 236 | 5 |
702874 | 702874 | 2020-11-05 | Greenbrier | West Virginia | 54025 | 231 | 4 |
699631 | 699631 | 2020-11-04 | Greenbrier | West Virginia | 54025 | 225 | 4 |
696387 | 696387 | 2020-11-03 | Greenbrier | West Virginia | 54025 | 216 | 4 |
693145 | 693145 | 2020-11-02 | Greenbrier | West Virginia | 54025 | 215 | 4 |
689901 | 689901 | 2020-11-01 | Greenbrier | West Virginia | 54025 | 217 | 4 |
686656 | 686656 | 2020-10-31 | Greenbrier | West Virginia | 54025 | 210 | 4 |
683413 | 683413 | 2020-10-30 | Greenbrier | West Virginia | 54025 | 204 | 4 |
680170 | 680170 | 2020-10-29 | Greenbrier | West Virginia | 54025 | 200 | 4 |
676927 | 676927 | 2020-10-28 | Greenbrier | West Virginia | 54025 | 195 | 4 |
673684 | 673684 | 2020-10-27 | Greenbrier | West Virginia | 54025 | 194 | 4 |
670442 | 670442 | 2020-10-26 | Greenbrier | West Virginia | 54025 | 181 | 4 |
667199 | 667199 | 2020-10-25 | Greenbrier | West Virginia | 54025 | 174 | 4 |
663954 | 663954 | 2020-10-24 | Greenbrier | West Virginia | 54025 | 171 | 4 |
660710 | 660710 | 2020-10-23 | Greenbrier | West Virginia | 54025 | 167 | 4 |
657466 | 657466 | 2020-10-22 | Greenbrier | West Virginia | 54025 | 165 | 4 |
654221 | 654221 | 2020-10-21 | Greenbrier | West Virginia | 54025 | 162 | 3 |
650976 | 650976 | 2020-10-20 | Greenbrier | West Virginia | 54025 | 161 | 3 |
647732 | 647732 | 2020-10-19 | Greenbrier | West Virginia | 54025 | 160 | 3 |
644486 | 644486 | 2020-10-18 | Greenbrier | West Virginia | 54025 | 156 | 3 |
641238 | 641238 | 2020-10-17 | Greenbrier | West Virginia | 54025 | 153 | 3 |
637991 | 637991 | 2020-10-16 | Greenbrier | West Virginia | 54025 | 151 | 3 |
634746 | 634746 | 2020-10-15 | Greenbrier | West Virginia | 54025 | 146 | 3 |
631501 | 631501 | 2020-10-14 | Greenbrier | West Virginia | 54025 | 145 | 3 |
628257 | 628257 | 2020-10-13 | Greenbrier | West Virginia | 54025 | 143 | 3 |
625014 | 625014 | 2020-10-12 | Greenbrier | West Virginia | 54025 | 140 | 3 |
621771 | 621771 | 2020-10-11 | Greenbrier | West Virginia | 54025 | 140 | 3 |
618528 | 618528 | 2020-10-10 | Greenbrier | West Virginia | 54025 | 141 | 3 |
615286 | 615286 | 2020-10-09 | Greenbrier | West Virginia | 54025 | 142 | 3 |
612045 | 612045 | 2020-10-08 | Greenbrier | West Virginia | 54025 | 139 | 3 |
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);