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 |
---|---|---|---|---|---|---|---|
1196237 | 1196237 | 2021-04-06 | Monongalia | West Virginia | 54061 | 8731 | 85 |
1192989 | 1192989 | 2021-04-05 | Monongalia | West Virginia | 54061 | 8720 | 85 |
1189739 | 1189739 | 2021-04-04 | Monongalia | West Virginia | 54061 | 8709 | 85 |
1186492 | 1186492 | 2021-04-03 | Monongalia | West Virginia | 54061 | 8697 | 85 |
1183245 | 1183245 | 2021-04-02 | Monongalia | West Virginia | 54061 | 8675 | 85 |
1179998 | 1179998 | 2021-04-01 | Monongalia | West Virginia | 54061 | 8683 | 85 |
1176751 | 1176751 | 2021-03-31 | Monongalia | West Virginia | 54061 | 8655 | 85 |
1173504 | 1173504 | 2021-03-30 | Monongalia | West Virginia | 54061 | 8633 | 85 |
1170257 | 1170257 | 2021-03-29 | Monongalia | West Virginia | 54061 | 8628 | 85 |
1167009 | 1167009 | 2021-03-28 | Monongalia | West Virginia | 54061 | 8612 | 85 |
1163761 | 1163761 | 2021-03-27 | Monongalia | West Virginia | 54061 | 8587 | 85 |
1160513 | 1160513 | 2021-03-26 | Monongalia | West Virginia | 54061 | 8548 | 84 |
1157265 | 1157265 | 2021-03-25 | Monongalia | West Virginia | 54061 | 8515 | 83 |
1154018 | 1154018 | 2021-03-24 | Monongalia | West Virginia | 54061 | 8494 | 83 |
1150771 | 1150771 | 2021-03-23 | Monongalia | West Virginia | 54061 | 8467 | 83 |
1147524 | 1147524 | 2021-03-22 | Monongalia | West Virginia | 54061 | 8458 | 84 |
1144277 | 1144277 | 2021-03-21 | Monongalia | West Virginia | 54061 | 8442 | 83 |
1141030 | 1141030 | 2021-03-20 | Monongalia | West Virginia | 54061 | 8419 | 83 |
1137784 | 1137784 | 2021-03-19 | Monongalia | West Virginia | 54061 | 8398 | 84 |
1134538 | 1134538 | 2021-03-18 | Monongalia | West Virginia | 54061 | 8376 | 82 |
1131290 | 1131290 | 2021-03-17 | Monongalia | West Virginia | 54061 | 8346 | 81 |
1128043 | 1128043 | 2021-03-16 | Monongalia | West Virginia | 54061 | 8328 | 81 |
1124797 | 1124797 | 2021-03-15 | Monongalia | West Virginia | 54061 | 8308 | 81 |
1121551 | 1121551 | 2021-03-14 | Monongalia | West Virginia | 54061 | 8296 | 81 |
1118304 | 1118304 | 2021-03-13 | Monongalia | West Virginia | 54061 | 8276 | 81 |
1115057 | 1115057 | 2021-03-12 | Monongalia | West Virginia | 54061 | 8260 | 81 |
1111811 | 1111811 | 2021-03-11 | Monongalia | West Virginia | 54061 | 8243 | 71 |
1108565 | 1108565 | 2021-03-10 | Monongalia | West Virginia | 54061 | 8227 | 71 |
1105319 | 1105319 | 2021-03-09 | Monongalia | West Virginia | 54061 | 8208 | 71 |
1102073 | 1102073 | 2021-03-08 | Monongalia | West Virginia | 54061 | 8192 | 71 |
1098827 | 1098827 | 2021-03-07 | Monongalia | West Virginia | 54061 | 8175 | 71 |
1095579 | 1095579 | 2021-03-06 | Monongalia | West Virginia | 54061 | 8157 | 71 |
1092333 | 1092333 | 2021-03-05 | Monongalia | West Virginia | 54061 | 8129 | 71 |
1089087 | 1089087 | 2021-03-04 | Monongalia | West Virginia | 54061 | 8106 | 71 |
1085842 | 1085842 | 2021-03-03 | Monongalia | West Virginia | 54061 | 8073 | 71 |
1082596 | 1082596 | 2021-03-02 | Monongalia | West Virginia | 54061 | 8054 | 70 |
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 |
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);