ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
60 rows where cases = 24 and state = "West Virginia" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: deaths, date (date)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
667223 | 667223 | 2020-10-25 | Pleasants | West Virginia | 54073 | 24 | 3 |
663978 | 663978 | 2020-10-24 | Pleasants | West Virginia | 54073 | 24 | 3 |
651011 | 651011 | 2020-10-20 | Tyler | West Virginia | 54095 | 24 | 0 |
647767 | 647767 | 2020-10-19 | Tyler | West Virginia | 54095 | 24 | 0 |
647770 | 647770 | 2020-10-19 | Webster | West Virginia | 54101 | 24 | 0 |
644521 | 644521 | 2020-10-18 | Tyler | West Virginia | 54095 | 24 | 0 |
641273 | 641273 | 2020-10-17 | Tyler | West Virginia | 54095 | 24 | 0 |
638026 | 638026 | 2020-10-16 | Tyler | West Virginia | 54095 | 24 | 0 |
634781 | 634781 | 2020-10-15 | Tyler | West Virginia | 54095 | 24 | 0 |
631536 | 631536 | 2020-10-14 | Tyler | West Virginia | 54095 | 24 | 0 |
560176 | 560176 | 2020-09-22 | Calhoun | West Virginia | 54013 | 24 | 0 |
556940 | 556940 | 2020-09-21 | Calhoun | West Virginia | 54013 | 24 | 0 |
553703 | 553703 | 2020-09-20 | Calhoun | West Virginia | 54013 | 24 | 0 |
476099 | 476099 | 2020-08-27 | Roane | West Virginia | 54087 | 24 | 1 |
463176 | 463176 | 2020-08-23 | Roane | West Virginia | 54087 | 24 | 1 |
405143 | 405143 | 2020-08-05 | Wyoming | West Virginia | 54109 | 24 | 1 |
372957 | 372957 | 2020-07-26 | Nicholas | West Virginia | 54067 | 24 | 1 |
344079 | 344079 | 2020-07-17 | Barbour | West Virginia | 54001 | 24 | 1 |
340880 | 340880 | 2020-07-16 | Barbour | West Virginia | 54001 | 24 | 1 |
340899 | 340899 | 2020-07-16 | Lewis | West Virginia | 54041 | 24 | 2 |
337703 | 337703 | 2020-07-15 | Lewis | West Virginia | 54041 | 24 | 2 |
328129 | 328129 | 2020-07-12 | Lewis | West Virginia | 54041 | 24 | 2 |
328134 | 328134 | 2020-07-12 | Mason | West Virginia | 54053 | 24 | 0 |
324928 | 324928 | 2020-07-11 | Brooke | West Virginia | 54009 | 24 | 0 |
324948 | 324948 | 2020-07-11 | Mason | West Virginia | 54053 | 24 | 0 |
309049 | 309049 | 2020-07-06 | Boone | West Virginia | 54005 | 24 | 0 |
293255 | 293255 | 2020-07-01 | Logan | West Virginia | 54045 | 24 | 1 |
286967 | 286967 | 2020-06-29 | Pocahontas | West Virginia | 54075 | 24 | 0 |
283821 | 283821 | 2020-06-28 | Pocahontas | West Virginia | 54075 | 24 | 0 |
280675 | 280675 | 2020-06-27 | Pocahontas | West Virginia | 54075 | 24 | 0 |
277527 | 277527 | 2020-06-26 | Pocahontas | West Virginia | 54075 | 24 | 0 |
274379 | 274379 | 2020-06-25 | Pocahontas | West Virginia | 54075 | 24 | 0 |
271239 | 271239 | 2020-06-24 | Pocahontas | West Virginia | 54075 | 24 | 0 |
268105 | 268105 | 2020-06-23 | Pocahontas | West Virginia | 54075 | 24 | 0 |
264976 | 264976 | 2020-06-22 | Pocahontas | West Virginia | 54075 | 24 | 0 |
261847 | 261847 | 2020-06-21 | Pocahontas | West Virginia | 54075 | 24 | 0 |
258720 | 258720 | 2020-06-20 | Pocahontas | West Virginia | 54075 | 24 | 0 |
243135 | 243135 | 2020-06-15 | Preston | West Virginia | 54077 | 24 | 2 |
240024 | 240024 | 2020-06-14 | Preston | West Virginia | 54077 | 24 | 2 |
236916 | 236916 | 2020-06-13 | Preston | West Virginia | 54077 | 24 | 2 |
233809 | 233809 | 2020-06-12 | Preston | West Virginia | 54077 | 24 | 2 |
230704 | 230704 | 2020-06-11 | Preston | West Virginia | 54077 | 24 | 2 |
227600 | 227600 | 2020-06-10 | Preston | West Virginia | 54077 | 24 | 2 |
224500 | 224500 | 2020-06-09 | Preston | West Virginia | 54077 | 24 | 2 |
221404 | 221404 | 2020-06-08 | Preston | West Virginia | 54077 | 24 | 2 |
218312 | 218312 | 2020-06-07 | Preston | West Virginia | 54077 | 24 | 2 |
215222 | 215222 | 2020-06-06 | Preston | West Virginia | 54077 | 24 | 2 |
212135 | 212135 | 2020-06-05 | Preston | West Virginia | 54077 | 24 | 2 |
209050 | 209050 | 2020-06-04 | Preston | West Virginia | 54077 | 24 | 2 |
205968 | 205968 | 2020-06-03 | Preston | West Virginia | 54077 | 24 | 2 |
202889 | 202889 | 2020-06-02 | Preston | West Virginia | 54077 | 24 | 2 |
181431 | 181431 | 2020-05-26 | Pocahontas | West Virginia | 54075 | 24 | 0 |
178387 | 178387 | 2020-05-25 | Pocahontas | West Virginia | 54075 | 24 | 0 |
175342 | 175342 | 2020-05-24 | Pocahontas | West Virginia | 54075 | 24 | 0 |
169258 | 169258 | 2020-05-22 | Pocahontas | West Virginia | 54075 | 24 | 0 |
154111 | 154111 | 2020-05-17 | Marshall | West Virginia | 54051 | 24 | 0 |
83945 | 83945 | 2020-04-23 | Ohio | West Virginia | 54069 | 24 | 1 |
56330 | 56330 | 2020-04-13 | Cabell | West Virginia | 54011 | 24 | 0 |
35496 | 35496 | 2020-04-05 | Harrison | West Virginia | 54033 | 24 | 0 |
13969 | 13969 | 2020-03-26 | Monongalia | West Virginia | 54061 | 24 | 0 |
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);