ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
141 rows where cases = 11 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 |
---|---|---|---|---|---|---|---|
566692 | 566692 | 2020-09-24 | Ritchie | West Virginia | 54085 | 11 | 0 |
563451 | 563451 | 2020-09-23 | Ritchie | West Virginia | 54085 | 11 | 0 |
534315 | 534315 | 2020-09-14 | Ritchie | West Virginia | 54085 | 11 | 0 |
508399 | 508399 | 2020-09-06 | Doddridge | West Virginia | 54017 | 11 | 0 |
505167 | 505167 | 2020-09-05 | Doddridge | West Virginia | 54017 | 11 | 0 |
505205 | 505205 | 2020-09-05 | Tucker | West Virginia | 54093 | 11 | 0 |
501971 | 501971 | 2020-09-04 | Tucker | West Virginia | 54093 | 11 | 0 |
498737 | 498737 | 2020-09-03 | Tucker | West Virginia | 54093 | 11 | 0 |
495504 | 495504 | 2020-09-02 | Tucker | West Virginia | 54093 | 11 | 0 |
492270 | 492270 | 2020-09-01 | Tucker | West Virginia | 54093 | 11 | 0 |
489037 | 489037 | 2020-08-31 | Tucker | West Virginia | 54093 | 11 | 0 |
485804 | 485804 | 2020-08-30 | Tucker | West Virginia | 54093 | 11 | 0 |
482569 | 482569 | 2020-08-29 | Tucker | West Virginia | 54093 | 11 | 0 |
479335 | 479335 | 2020-08-28 | Tucker | West Virginia | 54093 | 11 | 0 |
476102 | 476102 | 2020-08-27 | Tucker | West Virginia | 54093 | 11 | 0 |
472869 | 472869 | 2020-08-26 | Tucker | West Virginia | 54093 | 11 | 0 |
469637 | 469637 | 2020-08-25 | Tucker | West Virginia | 54093 | 11 | 0 |
466408 | 466408 | 2020-08-24 | Tucker | West Virginia | 54093 | 11 | 0 |
463179 | 463179 | 2020-08-23 | Tucker | West Virginia | 54093 | 11 | 0 |
459950 | 459950 | 2020-08-22 | Tucker | West Virginia | 54093 | 11 | 0 |
456723 | 456723 | 2020-08-21 | Tucker | West Virginia | 54093 | 11 | 0 |
453495 | 453495 | 2020-08-20 | Tucker | West Virginia | 54093 | 11 | 0 |
450267 | 450267 | 2020-08-19 | Tucker | West Virginia | 54093 | 11 | 0 |
447039 | 447039 | 2020-08-18 | Tucker | West Virginia | 54093 | 11 | 0 |
443812 | 443812 | 2020-08-17 | Tucker | West Virginia | 54093 | 11 | 0 |
440586 | 440586 | 2020-08-16 | Tucker | West Virginia | 54093 | 11 | 0 |
437360 | 437360 | 2020-08-15 | Tucker | West Virginia | 54093 | 11 | 0 |
434134 | 434134 | 2020-08-14 | Tucker | West Virginia | 54093 | 11 | 0 |
430909 | 430909 | 2020-08-13 | Tucker | West Virginia | 54093 | 11 | 0 |
418013 | 418013 | 2020-08-09 | Summers | West Virginia | 54089 | 11 | 0 |
411574 | 411574 | 2020-08-07 | Tucker | West Virginia | 54093 | 11 | 0 |
408355 | 408355 | 2020-08-06 | Tucker | West Virginia | 54093 | 11 | 0 |
405135 | 405135 | 2020-08-05 | Tucker | West Virginia | 54093 | 11 | 0 |
401917 | 401917 | 2020-08-04 | Tucker | West Virginia | 54093 | 11 | 0 |
398701 | 398701 | 2020-08-03 | Tucker | West Virginia | 54093 | 11 | 0 |
382618 | 382618 | 2020-07-29 | Tyler | West Virginia | 54095 | 11 | 0 |
379401 | 379401 | 2020-07-28 | Tyler | West Virginia | 54095 | 11 | 0 |
376185 | 376185 | 2020-07-27 | Tyler | West Virginia | 54095 | 11 | 0 |
372971 | 372971 | 2020-07-26 | Tyler | West Virginia | 54095 | 11 | 0 |
369759 | 369759 | 2020-07-25 | Tyler | West Virginia | 54095 | 11 | 0 |
366549 | 366549 | 2020-07-24 | Tyler | West Virginia | 54095 | 11 | 0 |
363321 | 363321 | 2020-07-23 | McDowell | West Virginia | 54047 | 11 | 0 |
356910 | 356910 | 2020-07-21 | McDowell | West Virginia | 54047 | 11 | 0 |
356938 | 356938 | 2020-07-21 | Wyoming | West Virginia | 54109 | 11 | 0 |
353707 | 353707 | 2020-07-20 | McDowell | West Virginia | 54047 | 11 | 0 |
334514 | 334514 | 2020-07-14 | McDowell | West Virginia | 54047 | 11 | 0 |
321750 | 321750 | 2020-07-10 | Clay | West Virginia | 54015 | 11 | 1 |
318571 | 318571 | 2020-07-09 | Clay | West Virginia | 54015 | 11 | 1 |
315398 | 315398 | 2020-07-08 | Clay | West Virginia | 54015 | 11 | 1 |
315433 | 315433 | 2020-07-08 | Roane | West Virginia | 54087 | 11 | 1 |
312223 | 312223 | 2020-07-07 | Clay | West Virginia | 54015 | 11 | 1 |
312258 | 312258 | 2020-07-07 | Roane | West Virginia | 54087 | 11 | 1 |
309054 | 309054 | 2020-07-06 | Clay | West Virginia | 54015 | 11 | 1 |
309089 | 309089 | 2020-07-06 | Roane | West Virginia | 54087 | 11 | 1 |
305886 | 305886 | 2020-07-05 | Clay | West Virginia | 54015 | 11 | 1 |
305921 | 305921 | 2020-07-05 | Roane | West Virginia | 54087 | 11 | 1 |
302757 | 302757 | 2020-07-04 | Roane | West Virginia | 54087 | 11 | 1 |
299593 | 299593 | 2020-07-03 | Roane | West Virginia | 54087 | 11 | 1 |
296431 | 296431 | 2020-07-02 | Roane | West Virginia | 54087 | 11 | 1 |
293266 | 293266 | 2020-07-01 | Nicholas | West Virginia | 54067 | 11 | 1 |
293276 | 293276 | 2020-07-01 | Roane | West Virginia | 54087 | 11 | 1 |
290123 | 290123 | 2020-06-30 | Roane | West Virginia | 54087 | 11 | 1 |
286973 | 286973 | 2020-06-29 | Roane | West Virginia | 54087 | 11 | 1 |
283815 | 283815 | 2020-06-28 | Monroe | West Virginia | 54063 | 11 | 0 |
283827 | 283827 | 2020-06-28 | Roane | West Virginia | 54087 | 11 | 1 |
280669 | 280669 | 2020-06-27 | Monroe | West Virginia | 54063 | 11 | 0 |
280681 | 280681 | 2020-06-27 | Roane | West Virginia | 54087 | 11 | 1 |
277533 | 277533 | 2020-06-26 | Roane | West Virginia | 54087 | 11 | 1 |
274352 | 274352 | 2020-06-25 | Gilmer | West Virginia | 54021 | 11 | 0 |
274385 | 274385 | 2020-06-25 | Roane | West Virginia | 54087 | 11 | 1 |
271207 | 271207 | 2020-06-24 | Brooke | West Virginia | 54009 | 11 | 0 |
271245 | 271245 | 2020-06-24 | Roane | West Virginia | 54087 | 11 | 1 |
268111 | 268111 | 2020-06-23 | Roane | West Virginia | 54087 | 11 | 1 |
258684 | 258684 | 2020-06-20 | Barbour | West Virginia | 54001 | 11 | 1 |
258731 | 258731 | 2020-06-20 | Upshur | West Virginia | 54097 | 11 | 0 |
255557 | 255557 | 2020-06-19 | Barbour | West Virginia | 54001 | 11 | 1 |
255599 | 255599 | 2020-06-19 | Roane | West Virginia | 54087 | 11 | 1 |
252438 | 252438 | 2020-06-18 | Barbour | West Virginia | 54001 | 11 | 1 |
252480 | 252480 | 2020-06-18 | Roane | West Virginia | 54087 | 11 | 1 |
252485 | 252485 | 2020-06-18 | Upshur | West Virginia | 54097 | 11 | 0 |
249323 | 249323 | 2020-06-17 | Barbour | West Virginia | 54001 | 11 | 1 |
249365 | 249365 | 2020-06-17 | Roane | West Virginia | 54087 | 11 | 1 |
246253 | 246253 | 2020-06-16 | Roane | West Virginia | 54087 | 11 | 1 |
243140 | 243140 | 2020-06-15 | Roane | West Virginia | 54087 | 11 | 1 |
233783 | 233783 | 2020-06-12 | Greenbrier | West Virginia | 54025 | 11 | 0 |
230695 | 230695 | 2020-06-11 | Mingo | West Virginia | 54059 | 11 | 1 |
215187 | 215187 | 2020-06-06 | Boone | West Virginia | 54005 | 11 | 0 |
212100 | 212100 | 2020-06-05 | Boone | West Virginia | 54005 | 11 | 0 |
209015 | 209015 | 2020-06-04 | Boone | West Virginia | 54005 | 11 | 0 |
187513 | 187513 | 2020-05-28 | Grant | West Virginia | 54023 | 11 | 0 |
187537 | 187537 | 2020-05-28 | Pendleton | West Virginia | 54071 | 11 | 0 |
184456 | 184456 | 2020-05-27 | Grant | West Virginia | 54023 | 11 | 0 |
181405 | 181405 | 2020-05-26 | Grant | West Virginia | 54023 | 11 | 0 |
178361 | 178361 | 2020-05-25 | Grant | West Virginia | 54023 | 11 | 0 |
175316 | 175316 | 2020-05-24 | Grant | West Virginia | 54023 | 11 | 0 |
145077 | 145077 | 2020-05-14 | Hampshire | West Virginia | 54027 | 11 | 1 |
136107 | 136107 | 2020-05-11 | Mercer | West Virginia | 54055 | 11 | 0 |
133117 | 133117 | 2020-05-10 | Mercer | West Virginia | 54055 | 11 | 0 |
130127 | 130127 | 2020-05-09 | Mercer | West Virginia | 54055 | 11 | 0 |
127137 | 127137 | 2020-05-08 | Mercer | West Virginia | 54055 | 11 | 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);