ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
781 rows where fips = 54077 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 |
---|---|---|---|---|---|---|---|
1085850 | 1085850 | 2021-03-03 | Preston | West Virginia | 54077 | 2548 | 43 |
1082604 | 1082604 | 2021-03-02 | Preston | West Virginia | 54077 | 2544 | 43 |
1079358 | 1079358 | 2021-03-01 | Preston | West Virginia | 54077 | 2542 | 43 |
1076113 | 1076113 | 2021-02-28 | Preston | West Virginia | 54077 | 2536 | 43 |
1072867 | 1072867 | 2021-02-27 | Preston | West Virginia | 54077 | 2531 | 42 |
1069621 | 1069621 | 2021-02-26 | Preston | West Virginia | 54077 | 2528 | 42 |
1066376 | 1066376 | 2021-02-25 | Preston | West Virginia | 54077 | 2525 | 42 |
1063131 | 1063131 | 2021-02-24 | Preston | West Virginia | 54077 | 2518 | 42 |
1059886 | 1059886 | 2021-02-23 | Preston | West Virginia | 54077 | 2519 | 42 |
1056640 | 1056640 | 2021-02-22 | Preston | West Virginia | 54077 | 2512 | 41 |
1053394 | 1053394 | 2021-02-21 | Preston | West Virginia | 54077 | 2505 | 41 |
1050147 | 1050147 | 2021-02-20 | Preston | West Virginia | 54077 | 2505 | 41 |
1046900 | 1046900 | 2021-02-19 | Preston | West Virginia | 54077 | 2499 | 41 |
1043655 | 1043655 | 2021-02-18 | Preston | West Virginia | 54077 | 2496 | 41 |
1040410 | 1040410 | 2021-02-17 | Preston | West Virginia | 54077 | 2488 | 41 |
1037165 | 1037165 | 2021-02-16 | Preston | West Virginia | 54077 | 2485 | 41 |
1033920 | 1033920 | 2021-02-15 | Preston | West Virginia | 54077 | 2485 | 41 |
1030674 | 1030674 | 2021-02-14 | Preston | West Virginia | 54077 | 2481 | 41 |
1027427 | 1027427 | 2021-02-13 | Preston | West Virginia | 54077 | 2479 | 41 |
1024182 | 1024182 | 2021-02-12 | Preston | West Virginia | 54077 | 2477 | 40 |
1020937 | 1020937 | 2021-02-11 | Preston | West Virginia | 54077 | 2473 | 40 |
1017692 | 1017692 | 2021-02-10 | Preston | West Virginia | 54077 | 2468 | 40 |
1014447 | 1014447 | 2021-02-09 | Preston | West Virginia | 54077 | 2461 | 40 |
1011202 | 1011202 | 2021-02-08 | Preston | West Virginia | 54077 | 2468 | 40 |
1007956 | 1007956 | 2021-02-07 | Preston | West Virginia | 54077 | 2463 | 40 |
1004710 | 1004710 | 2021-02-06 | Preston | West Virginia | 54077 | 2459 | 40 |
1001464 | 1001464 | 2021-02-05 | Preston | West Virginia | 54077 | 2452 | 40 |
998218 | 998218 | 2021-02-04 | Preston | West Virginia | 54077 | 2443 | 40 |
994972 | 994972 | 2021-02-03 | Preston | West Virginia | 54077 | 2436 | 40 |
991726 | 991726 | 2021-02-02 | Preston | West Virginia | 54077 | 2433 | 38 |
988480 | 988480 | 2021-02-01 | Preston | West Virginia | 54077 | 2431 | 38 |
985233 | 985233 | 2021-01-31 | Preston | West Virginia | 54077 | 2425 | 38 |
981986 | 981986 | 2021-01-30 | Preston | West Virginia | 54077 | 2419 | 38 |
978740 | 978740 | 2021-01-29 | Preston | West Virginia | 54077 | 2408 | 38 |
975495 | 975495 | 2021-01-28 | Preston | West Virginia | 54077 | 2392 | 38 |
972250 | 972250 | 2021-01-27 | Preston | West Virginia | 54077 | 2382 | 37 |
969005 | 969005 | 2021-01-26 | Preston | West Virginia | 54077 | 2378 | 37 |
965761 | 965761 | 2021-01-25 | Preston | West Virginia | 54077 | 2365 | 37 |
962516 | 962516 | 2021-01-24 | Preston | West Virginia | 54077 | 2341 | 37 |
959271 | 959271 | 2021-01-23 | Preston | West Virginia | 54077 | 2336 | 37 |
956025 | 956025 | 2021-01-22 | Preston | West Virginia | 54077 | 2315 | 35 |
952780 | 952780 | 2021-01-21 | Preston | West Virginia | 54077 | 2305 | 35 |
949535 | 949535 | 2021-01-20 | Preston | West Virginia | 54077 | 2266 | 35 |
946289 | 946289 | 2021-01-19 | Preston | West Virginia | 54077 | 2258 | 34 |
943042 | 943042 | 2021-01-18 | Preston | West Virginia | 54077 | 2234 | 34 |
939797 | 939797 | 2021-01-17 | Preston | West Virginia | 54077 | 2213 | 34 |
936552 | 936552 | 2021-01-16 | Preston | West Virginia | 54077 | 2206 | 34 |
933307 | 933307 | 2021-01-15 | Preston | West Virginia | 54077 | 2167 | 34 |
930062 | 930062 | 2021-01-14 | Preston | West Virginia | 54077 | 2117 | 34 |
926817 | 926817 | 2021-01-13 | Preston | West Virginia | 54077 | 2083 | 34 |
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 |
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);