ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
786 rows where fips = 54061 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 |
---|---|---|---|---|---|---|---|
1079350 | 1079350 | 2021-03-01 | Monongalia | West Virginia | 54061 | 8049 | 70 |
1076105 | 1076105 | 2021-02-28 | Monongalia | West Virginia | 54061 | 8025 | 70 |
1072859 | 1072859 | 2021-02-27 | Monongalia | West Virginia | 54061 | 7994 | 70 |
1069613 | 1069613 | 2021-02-26 | Monongalia | West Virginia | 54061 | 7949 | 70 |
1066368 | 1066368 | 2021-02-25 | Monongalia | West Virginia | 54061 | 7907 | 70 |
1063123 | 1063123 | 2021-02-24 | Monongalia | West Virginia | 54061 | 7837 | 70 |
1059878 | 1059878 | 2021-02-23 | Monongalia | West Virginia | 54061 | 7815 | 70 |
1056632 | 1056632 | 2021-02-22 | Monongalia | West Virginia | 54061 | 7796 | 70 |
1053386 | 1053386 | 2021-02-21 | Monongalia | West Virginia | 54061 | 7778 | 70 |
1050139 | 1050139 | 2021-02-20 | Monongalia | West Virginia | 54061 | 7739 | 68 |
1046892 | 1046892 | 2021-02-19 | Monongalia | West Virginia | 54061 | 7716 | 68 |
1043647 | 1043647 | 2021-02-18 | Monongalia | West Virginia | 54061 | 7690 | 68 |
1040402 | 1040402 | 2021-02-17 | Monongalia | West Virginia | 54061 | 7650 | 68 |
1037157 | 1037157 | 2021-02-16 | Monongalia | West Virginia | 54061 | 7625 | 68 |
1033912 | 1033912 | 2021-02-15 | Monongalia | West Virginia | 54061 | 7610 | 68 |
1030666 | 1030666 | 2021-02-14 | Monongalia | West Virginia | 54061 | 7591 | 68 |
1027419 | 1027419 | 2021-02-13 | Monongalia | West Virginia | 54061 | 7542 | 67 |
1024174 | 1024174 | 2021-02-12 | Monongalia | West Virginia | 54061 | 7513 | 67 |
1020929 | 1020929 | 2021-02-11 | Monongalia | West Virginia | 54061 | 7472 | 67 |
1017684 | 1017684 | 2021-02-10 | Monongalia | West Virginia | 54061 | 7441 | 67 |
1014439 | 1014439 | 2021-02-09 | Monongalia | West Virginia | 54061 | 7398 | 63 |
1011194 | 1011194 | 2021-02-08 | Monongalia | West Virginia | 54061 | 7365 | 63 |
1007948 | 1007948 | 2021-02-07 | Monongalia | West Virginia | 54061 | 7347 | 63 |
1004702 | 1004702 | 2021-02-06 | Monongalia | West Virginia | 54061 | 7299 | 63 |
1001456 | 1001456 | 2021-02-05 | Monongalia | West Virginia | 54061 | 7262 | 62 |
998210 | 998210 | 2021-02-04 | Monongalia | West Virginia | 54061 | 7224 | 62 |
994964 | 994964 | 2021-02-03 | Monongalia | West Virginia | 54061 | 7183 | 61 |
991718 | 991718 | 2021-02-02 | Monongalia | West Virginia | 54061 | 7153 | 61 |
988472 | 988472 | 2021-02-01 | Monongalia | West Virginia | 54061 | 7138 | 60 |
985225 | 985225 | 2021-01-31 | Monongalia | West Virginia | 54061 | 7114 | 60 |
981978 | 981978 | 2021-01-30 | Monongalia | West Virginia | 54061 | 7076 | 60 |
978732 | 978732 | 2021-01-29 | Monongalia | West Virginia | 54061 | 7029 | 59 |
975487 | 975487 | 2021-01-28 | Monongalia | West Virginia | 54061 | 6944 | 58 |
972242 | 972242 | 2021-01-27 | Monongalia | West Virginia | 54061 | 6906 | 57 |
968997 | 968997 | 2021-01-26 | Monongalia | West Virginia | 54061 | 6871 | 57 |
965753 | 965753 | 2021-01-25 | Monongalia | West Virginia | 54061 | 6839 | 54 |
962508 | 962508 | 2021-01-24 | Monongalia | West Virginia | 54061 | 6793 | 54 |
959263 | 959263 | 2021-01-23 | Monongalia | West Virginia | 54061 | 6741 | 54 |
956017 | 956017 | 2021-01-22 | Monongalia | West Virginia | 54061 | 6689 | 54 |
952772 | 952772 | 2021-01-21 | Monongalia | West Virginia | 54061 | 6648 | 54 |
949527 | 949527 | 2021-01-20 | Monongalia | West Virginia | 54061 | 6574 | 54 |
946281 | 946281 | 2021-01-19 | Monongalia | West Virginia | 54061 | 6543 | 55 |
943034 | 943034 | 2021-01-18 | Monongalia | West Virginia | 54061 | 6500 | 54 |
939789 | 939789 | 2021-01-17 | Monongalia | West Virginia | 54061 | 6432 | 53 |
936544 | 936544 | 2021-01-16 | Monongalia | West Virginia | 54061 | 6401 | 52 |
933299 | 933299 | 2021-01-15 | Monongalia | West Virginia | 54061 | 6311 | 52 |
930054 | 930054 | 2021-01-14 | Monongalia | West Virginia | 54061 | 6244 | 51 |
926809 | 926809 | 2021-01-13 | Monongalia | West Virginia | 54061 | 6217 | 49 |
923563 | 923563 | 2021-01-12 | Monongalia | West Virginia | 54061 | 6157 | 49 |
920318 | 920318 | 2021-01-11 | Monongalia | West Virginia | 54061 | 6110 | 45 |
917073 | 917073 | 2021-01-10 | Monongalia | West Virginia | 54061 | 6049 | 45 |
913828 | 913828 | 2021-01-09 | Monongalia | West Virginia | 54061 | 5989 | 45 |
910583 | 910583 | 2021-01-08 | Monongalia | West Virginia | 54061 | 5925 | 44 |
907338 | 907338 | 2021-01-07 | Monongalia | West Virginia | 54061 | 5823 | 44 |
904092 | 904092 | 2021-01-06 | Monongalia | West Virginia | 54061 | 5754 | 42 |
900847 | 900847 | 2021-01-05 | Monongalia | West Virginia | 54061 | 5698 | 40 |
897602 | 897602 | 2021-01-04 | Monongalia | West Virginia | 54061 | 5635 | 32 |
894356 | 894356 | 2021-01-03 | Monongalia | West Virginia | 54061 | 5578 | 31 |
891110 | 891110 | 2021-01-02 | Monongalia | West Virginia | 54061 | 5494 | 31 |
887863 | 887863 | 2021-01-01 | Monongalia | West Virginia | 54061 | 5427 | 31 |
884618 | 884618 | 2020-12-31 | Monongalia | West Virginia | 54061 | 5284 | 31 |
881373 | 881373 | 2020-12-30 | Monongalia | West Virginia | 54061 | 5269 | 30 |
878128 | 878128 | 2020-12-29 | Monongalia | West Virginia | 54061 | 5173 | 29 |
874883 | 874883 | 2020-12-28 | Monongalia | West Virginia | 54061 | 5110 | 26 |
871638 | 871638 | 2020-12-27 | Monongalia | West Virginia | 54061 | 5076 | 25 |
868393 | 868393 | 2020-12-26 | Monongalia | West Virginia | 54061 | 5034 | 25 |
865148 | 865148 | 2020-12-25 | Monongalia | West Virginia | 54061 | 4989 | 25 |
861903 | 861903 | 2020-12-24 | Monongalia | West Virginia | 54061 | 4915 | 25 |
858658 | 858658 | 2020-12-23 | Monongalia | West Virginia | 54061 | 4826 | 23 |
855413 | 855413 | 2020-12-22 | Monongalia | West Virginia | 54061 | 4778 | 22 |
852168 | 852168 | 2020-12-21 | Monongalia | West Virginia | 54061 | 4718 | 13 |
848923 | 848923 | 2020-12-20 | Monongalia | West Virginia | 54061 | 4668 | 13 |
845678 | 845678 | 2020-12-19 | Monongalia | West Virginia | 54061 | 4596 | 16 |
842432 | 842432 | 2020-12-18 | Monongalia | West Virginia | 54061 | 4512 | 11 |
839187 | 839187 | 2020-12-17 | Monongalia | West Virginia | 54061 | 4422 | 11 |
835942 | 835942 | 2020-12-16 | Monongalia | West Virginia | 54061 | 4319 | 9 |
832696 | 832696 | 2020-12-15 | Monongalia | West Virginia | 54061 | 4256 | 9 |
829449 | 829449 | 2020-12-14 | Monongalia | West Virginia | 54061 | 4171 | 8 |
826203 | 826203 | 2020-12-13 | Monongalia | West Virginia | 54061 | 4091 | 8 |
822956 | 822956 | 2020-12-12 | Monongalia | West Virginia | 54061 | 3995 | 7 |
819710 | 819710 | 2020-12-11 | Monongalia | West Virginia | 54061 | 3897 | 7 |
816464 | 816464 | 2020-12-10 | Monongalia | West Virginia | 54061 | 3851 | 7 |
813218 | 813218 | 2020-12-09 | Monongalia | West Virginia | 54061 | 3796 | 8 |
809974 | 809974 | 2020-12-08 | Monongalia | West Virginia | 54061 | 3738 | 7 |
806729 | 806729 | 2020-12-07 | Monongalia | West Virginia | 54061 | 3691 | 7 |
803484 | 803484 | 2020-12-06 | Monongalia | West Virginia | 54061 | 3626 | 7 |
800239 | 800239 | 2020-12-05 | Monongalia | West Virginia | 54061 | 3561 | 7 |
796994 | 796994 | 2020-12-04 | Monongalia | West Virginia | 54061 | 3490 | 7 |
793749 | 793749 | 2020-12-03 | Monongalia | West Virginia | 54061 | 3459 | 7 |
790504 | 790504 | 2020-12-02 | Monongalia | West Virginia | 54061 | 3400 | 7 |
787259 | 787259 | 2020-12-01 | Monongalia | West Virginia | 54061 | 3373 | 7 |
784015 | 784015 | 2020-11-30 | Monongalia | West Virginia | 54061 | 3341 | 7 |
780770 | 780770 | 2020-11-29 | Monongalia | West Virginia | 54061 | 3307 | 7 |
777524 | 777524 | 2020-11-28 | Monongalia | West Virginia | 54061 | 3284 | 7 |
774279 | 774279 | 2020-11-27 | Monongalia | West Virginia | 54061 | 3253 | 7 |
771034 | 771034 | 2020-11-26 | Monongalia | West Virginia | 54061 | 3202 | 7 |
767788 | 767788 | 2020-11-25 | Monongalia | West Virginia | 54061 | 3143 | 7 |
764543 | 764543 | 2020-11-24 | Monongalia | West Virginia | 54061 | 3107 | 7 |
761298 | 761298 | 2020-11-23 | Monongalia | West Virginia | 54061 | 3058 | 7 |
758053 | 758053 | 2020-11-22 | Monongalia | West Virginia | 54061 | 3018 | 7 |
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);