ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
767 rows where fips = 54109 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 |
---|---|---|---|---|---|---|---|
638033 | 638033 | 2020-10-16 | Wyoming | West Virginia | 54109 | 161 | 5 |
634788 | 634788 | 2020-10-15 | Wyoming | West Virginia | 54109 | 152 | 5 |
631543 | 631543 | 2020-10-14 | Wyoming | West Virginia | 54109 | 144 | 5 |
628299 | 628299 | 2020-10-13 | Wyoming | West Virginia | 54109 | 143 | 5 |
625056 | 625056 | 2020-10-12 | Wyoming | West Virginia | 54109 | 138 | 5 |
621813 | 621813 | 2020-10-11 | Wyoming | West Virginia | 54109 | 137 | 5 |
618570 | 618570 | 2020-10-10 | Wyoming | West Virginia | 54109 | 136 | 5 |
615328 | 615328 | 2020-10-09 | Wyoming | West Virginia | 54109 | 135 | 5 |
612087 | 612087 | 2020-10-08 | Wyoming | West Virginia | 54109 | 132 | 5 |
608845 | 608845 | 2020-10-07 | Wyoming | West Virginia | 54109 | 130 | 5 |
605602 | 605602 | 2020-10-06 | Wyoming | West Virginia | 54109 | 130 | 4 |
602360 | 602360 | 2020-10-05 | Wyoming | West Virginia | 54109 | 130 | 4 |
599117 | 599117 | 2020-10-04 | Wyoming | West Virginia | 54109 | 129 | 4 |
595874 | 595874 | 2020-10-03 | Wyoming | West Virginia | 54109 | 129 | 4 |
592632 | 592632 | 2020-10-02 | Wyoming | West Virginia | 54109 | 127 | 4 |
589392 | 589392 | 2020-10-01 | Wyoming | West Virginia | 54109 | 121 | 4 |
586151 | 586151 | 2020-09-30 | Wyoming | West Virginia | 54109 | 119 | 4 |
582911 | 582911 | 2020-09-29 | Wyoming | West Virginia | 54109 | 118 | 4 |
579672 | 579672 | 2020-09-28 | Wyoming | West Virginia | 54109 | 118 | 3 |
576431 | 576431 | 2020-09-27 | Wyoming | West Virginia | 54109 | 115 | 3 |
573187 | 573187 | 2020-09-26 | Wyoming | West Virginia | 54109 | 114 | 3 |
569945 | 569945 | 2020-09-25 | Wyoming | West Virginia | 54109 | 110 | 3 |
566704 | 566704 | 2020-09-24 | Wyoming | West Virginia | 54109 | 108 | 3 |
563463 | 563463 | 2020-09-23 | Wyoming | West Virginia | 54109 | 103 | 3 |
560224 | 560224 | 2020-09-22 | Wyoming | West Virginia | 54109 | 103 | 3 |
556988 | 556988 | 2020-09-21 | Wyoming | West Virginia | 54109 | 101 | 3 |
553751 | 553751 | 2020-09-20 | Wyoming | West Virginia | 54109 | 101 | 3 |
550512 | 550512 | 2020-09-19 | Wyoming | West Virginia | 54109 | 96 | 3 |
547273 | 547273 | 2020-09-18 | Wyoming | West Virginia | 54109 | 94 | 3 |
544036 | 544036 | 2020-09-17 | Wyoming | West Virginia | 54109 | 88 | 3 |
540800 | 540800 | 2020-09-16 | Wyoming | West Virginia | 54109 | 83 | 3 |
537563 | 537563 | 2020-09-15 | Wyoming | West Virginia | 54109 | 82 | 3 |
534327 | 534327 | 2020-09-14 | Wyoming | West Virginia | 54109 | 80 | 3 |
531092 | 531092 | 2020-09-13 | Wyoming | West Virginia | 54109 | 80 | 3 |
527855 | 527855 | 2020-09-12 | Wyoming | West Virginia | 54109 | 76 | 3 |
524619 | 524619 | 2020-09-11 | Wyoming | West Virginia | 54109 | 73 | 3 |
521383 | 521383 | 2020-09-10 | Wyoming | West Virginia | 54109 | 75 | 4 |
518146 | 518146 | 2020-09-09 | Wyoming | West Virginia | 54109 | 73 | 3 |
514911 | 514911 | 2020-09-08 | Wyoming | West Virginia | 54109 | 72 | 3 |
511678 | 511678 | 2020-09-07 | Wyoming | West Virginia | 54109 | 72 | 3 |
508445 | 508445 | 2020-09-06 | Wyoming | West Virginia | 54109 | 71 | 3 |
505213 | 505213 | 2020-09-05 | Wyoming | West Virginia | 54109 | 71 | 3 |
501979 | 501979 | 2020-09-04 | Wyoming | West Virginia | 54109 | 70 | 3 |
498745 | 498745 | 2020-09-03 | Wyoming | West Virginia | 54109 | 68 | 3 |
495512 | 495512 | 2020-09-02 | Wyoming | West Virginia | 54109 | 67 | 3 |
492278 | 492278 | 2020-09-01 | Wyoming | West Virginia | 54109 | 68 | 3 |
489045 | 489045 | 2020-08-31 | Wyoming | West Virginia | 54109 | 67 | 3 |
485812 | 485812 | 2020-08-30 | Wyoming | West Virginia | 54109 | 66 | 3 |
482577 | 482577 | 2020-08-29 | Wyoming | West Virginia | 54109 | 66 | 3 |
479343 | 479343 | 2020-08-28 | Wyoming | West Virginia | 54109 | 64 | 3 |
476110 | 476110 | 2020-08-27 | Wyoming | West Virginia | 54109 | 61 | 3 |
472877 | 472877 | 2020-08-26 | Wyoming | West Virginia | 54109 | 55 | 3 |
469645 | 469645 | 2020-08-25 | Wyoming | West Virginia | 54109 | 51 | 3 |
466416 | 466416 | 2020-08-24 | Wyoming | West Virginia | 54109 | 51 | 2 |
463187 | 463187 | 2020-08-23 | Wyoming | West Virginia | 54109 | 51 | 2 |
459958 | 459958 | 2020-08-22 | Wyoming | West Virginia | 54109 | 51 | 2 |
456731 | 456731 | 2020-08-21 | Wyoming | West Virginia | 54109 | 52 | 2 |
453503 | 453503 | 2020-08-20 | Wyoming | West Virginia | 54109 | 52 | 2 |
450275 | 450275 | 2020-08-19 | Wyoming | West Virginia | 54109 | 47 | 2 |
447047 | 447047 | 2020-08-18 | Wyoming | West Virginia | 54109 | 47 | 2 |
443820 | 443820 | 2020-08-17 | Wyoming | West Virginia | 54109 | 48 | 2 |
440594 | 440594 | 2020-08-16 | Wyoming | West Virginia | 54109 | 47 | 2 |
437368 | 437368 | 2020-08-15 | Wyoming | West Virginia | 54109 | 46 | 2 |
434142 | 434142 | 2020-08-14 | Wyoming | West Virginia | 54109 | 46 | 2 |
430917 | 430917 | 2020-08-13 | Wyoming | West Virginia | 54109 | 43 | 2 |
427689 | 427689 | 2020-08-12 | Wyoming | West Virginia | 54109 | 37 | 2 |
424465 | 424465 | 2020-08-11 | Wyoming | West Virginia | 54109 | 34 | 2 |
421244 | 421244 | 2020-08-10 | Wyoming | West Virginia | 54109 | 34 | 1 |
418023 | 418023 | 2020-08-09 | Wyoming | West Virginia | 54109 | 31 | 1 |
414802 | 414802 | 2020-08-08 | Wyoming | West Virginia | 54109 | 31 | 1 |
411582 | 411582 | 2020-08-07 | Wyoming | West Virginia | 54109 | 31 | 1 |
408363 | 408363 | 2020-08-06 | Wyoming | West Virginia | 54109 | 29 | 1 |
405143 | 405143 | 2020-08-05 | Wyoming | West Virginia | 54109 | 24 | 1 |
401925 | 401925 | 2020-08-04 | Wyoming | West Virginia | 54109 | 23 | 1 |
398709 | 398709 | 2020-08-03 | Wyoming | West Virginia | 54109 | 23 | 1 |
395493 | 395493 | 2020-08-02 | Wyoming | West Virginia | 54109 | 23 | 1 |
392277 | 392277 | 2020-08-01 | Wyoming | West Virginia | 54109 | 21 | 1 |
389060 | 389060 | 2020-07-31 | Wyoming | West Virginia | 54109 | 20 | 1 |
385843 | 385843 | 2020-07-30 | Wyoming | West Virginia | 54109 | 19 | 1 |
382625 | 382625 | 2020-07-29 | Wyoming | West Virginia | 54109 | 18 | 1 |
379408 | 379408 | 2020-07-28 | Wyoming | West Virginia | 54109 | 17 | 1 |
376192 | 376192 | 2020-07-27 | Wyoming | West Virginia | 54109 | 17 | 1 |
372978 | 372978 | 2020-07-26 | Wyoming | West Virginia | 54109 | 16 | 0 |
369766 | 369766 | 2020-07-25 | Wyoming | West Virginia | 54109 | 15 | 0 |
366556 | 366556 | 2020-07-24 | Wyoming | West Virginia | 54109 | 15 | 0 |
363349 | 363349 | 2020-07-23 | Wyoming | West Virginia | 54109 | 15 | 0 |
360143 | 360143 | 2020-07-22 | Wyoming | West Virginia | 54109 | 12 | 0 |
356938 | 356938 | 2020-07-21 | Wyoming | West Virginia | 54109 | 11 | 0 |
353735 | 353735 | 2020-07-20 | Wyoming | West Virginia | 54109 | 8 | 0 |
350533 | 350533 | 2020-07-19 | Wyoming | West Virginia | 54109 | 7 | 0 |
347332 | 347332 | 2020-07-18 | Wyoming | West Virginia | 54109 | 7 | 0 |
344132 | 344132 | 2020-07-17 | Wyoming | West Virginia | 54109 | 7 | 0 |
340933 | 340933 | 2020-07-16 | Wyoming | West Virginia | 54109 | 7 | 0 |
337737 | 337737 | 2020-07-15 | Wyoming | West Virginia | 54109 | 7 | 0 |
334542 | 334542 | 2020-07-14 | Wyoming | West Virginia | 54109 | 7 | 0 |
331349 | 331349 | 2020-07-13 | Wyoming | West Virginia | 54109 | 7 | 0 |
328163 | 328163 | 2020-07-12 | Wyoming | West Virginia | 54109 | 7 | 0 |
324977 | 324977 | 2020-07-11 | Wyoming | West Virginia | 54109 | 7 | 0 |
321796 | 321796 | 2020-07-10 | Wyoming | West Virginia | 54109 | 7 | 0 |
318617 | 318617 | 2020-07-09 | Wyoming | West Virginia | 54109 | 7 | 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);