ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
780 rows where county = "Logan" 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 |
---|---|---|---|---|---|---|---|
638001 | 638001 | 2020-10-16 | Logan | West Virginia | 54045 | 706 | 43 |
634756 | 634756 | 2020-10-15 | Logan | West Virginia | 54045 | 701 | 43 |
631511 | 631511 | 2020-10-14 | Logan | West Virginia | 54045 | 697 | 43 |
628267 | 628267 | 2020-10-13 | Logan | West Virginia | 54045 | 694 | 43 |
625024 | 625024 | 2020-10-12 | Logan | West Virginia | 54045 | 689 | 43 |
621781 | 621781 | 2020-10-11 | Logan | West Virginia | 54045 | 686 | 43 |
618538 | 618538 | 2020-10-10 | Logan | West Virginia | 54045 | 675 | 43 |
615296 | 615296 | 2020-10-09 | Logan | West Virginia | 54045 | 688 | 43 |
612055 | 612055 | 2020-10-08 | Logan | West Virginia | 54045 | 679 | 42 |
608813 | 608813 | 2020-10-07 | Logan | West Virginia | 54045 | 673 | 42 |
605570 | 605570 | 2020-10-06 | Logan | West Virginia | 54045 | 664 | 42 |
602328 | 602328 | 2020-10-05 | Logan | West Virginia | 54045 | 652 | 42 |
599085 | 599085 | 2020-10-04 | Logan | West Virginia | 54045 | 650 | 42 |
595842 | 595842 | 2020-10-03 | Logan | West Virginia | 54045 | 635 | 42 |
592600 | 592600 | 2020-10-02 | Logan | West Virginia | 54045 | 632 | 42 |
589360 | 589360 | 2020-10-01 | Logan | West Virginia | 54045 | 627 | 42 |
586119 | 586119 | 2020-09-30 | Logan | West Virginia | 54045 | 622 | 42 |
582879 | 582879 | 2020-09-29 | Logan | West Virginia | 54045 | 620 | 42 |
579640 | 579640 | 2020-09-28 | Logan | West Virginia | 54045 | 620 | 41 |
576399 | 576399 | 2020-09-27 | Logan | West Virginia | 54045 | 617 | 41 |
573155 | 573155 | 2020-09-26 | Logan | West Virginia | 54045 | 610 | 41 |
569913 | 569913 | 2020-09-25 | Logan | West Virginia | 54045 | 606 | 39 |
566672 | 566672 | 2020-09-24 | Logan | West Virginia | 54045 | 599 | 39 |
563431 | 563431 | 2020-09-23 | Logan | West Virginia | 54045 | 588 | 39 |
560192 | 560192 | 2020-09-22 | Logan | West Virginia | 54045 | 585 | 39 |
556956 | 556956 | 2020-09-21 | Logan | West Virginia | 54045 | 582 | 39 |
553719 | 553719 | 2020-09-20 | Logan | West Virginia | 54045 | 572 | 39 |
550480 | 550480 | 2020-09-19 | Logan | West Virginia | 54045 | 565 | 39 |
547241 | 547241 | 2020-09-18 | Logan | West Virginia | 54045 | 559 | 39 |
544004 | 544004 | 2020-09-17 | Logan | West Virginia | 54045 | 558 | 38 |
540768 | 540768 | 2020-09-16 | Logan | West Virginia | 54045 | 555 | 38 |
537531 | 537531 | 2020-09-15 | Logan | West Virginia | 54045 | 549 | 37 |
534295 | 534295 | 2020-09-14 | Logan | West Virginia | 54045 | 547 | 36 |
531060 | 531060 | 2020-09-13 | Logan | West Virginia | 54045 | 544 | 37 |
527823 | 527823 | 2020-09-12 | Logan | West Virginia | 54045 | 537 | 36 |
524587 | 524587 | 2020-09-11 | Logan | West Virginia | 54045 | 536 | 36 |
521351 | 521351 | 2020-09-10 | Logan | West Virginia | 54045 | 536 | 35 |
518114 | 518114 | 2020-09-09 | Logan | West Virginia | 54045 | 529 | 34 |
514879 | 514879 | 2020-09-08 | Logan | West Virginia | 54045 | 522 | 34 |
511646 | 511646 | 2020-09-07 | Logan | West Virginia | 54045 | 519 | 34 |
508413 | 508413 | 2020-09-06 | Logan | West Virginia | 54045 | 520 | 34 |
505181 | 505181 | 2020-09-05 | Logan | West Virginia | 54045 | 516 | 33 |
501947 | 501947 | 2020-09-04 | Logan | West Virginia | 54045 | 511 | 32 |
498713 | 498713 | 2020-09-03 | Logan | West Virginia | 54045 | 503 | 30 |
495480 | 495480 | 2020-09-02 | Logan | West Virginia | 54045 | 501 | 30 |
492246 | 492246 | 2020-09-01 | Logan | West Virginia | 54045 | 493 | 29 |
489013 | 489013 | 2020-08-31 | Logan | West Virginia | 54045 | 484 | 27 |
485780 | 485780 | 2020-08-30 | Logan | West Virginia | 54045 | 479 | 27 |
482545 | 482545 | 2020-08-29 | Logan | West Virginia | 54045 | 476 | 27 |
479311 | 479311 | 2020-08-28 | Logan | West Virginia | 54045 | 471 | 25 |
476078 | 476078 | 2020-08-27 | Logan | West Virginia | 54045 | 454 | 26 |
472845 | 472845 | 2020-08-26 | Logan | West Virginia | 54045 | 454 | 21 |
469613 | 469613 | 2020-08-25 | Logan | West Virginia | 54045 | 446 | 20 |
466384 | 466384 | 2020-08-24 | Logan | West Virginia | 54045 | 439 | 17 |
463155 | 463155 | 2020-08-23 | Logan | West Virginia | 54045 | 437 | 17 |
459926 | 459926 | 2020-08-22 | Logan | West Virginia | 54045 | 431 | 17 |
456699 | 456699 | 2020-08-21 | Logan | West Virginia | 54045 | 425 | 12 |
453471 | 453471 | 2020-08-20 | Logan | West Virginia | 54045 | 418 | 12 |
450243 | 450243 | 2020-08-19 | Logan | West Virginia | 54045 | 380 | 12 |
447015 | 447015 | 2020-08-18 | Logan | West Virginia | 54045 | 374 | 12 |
443788 | 443788 | 2020-08-17 | Logan | West Virginia | 54045 | 362 | 11 |
440562 | 440562 | 2020-08-16 | Logan | West Virginia | 54045 | 356 | 11 |
437336 | 437336 | 2020-08-15 | Logan | West Virginia | 54045 | 354 | 11 |
434110 | 434110 | 2020-08-14 | Logan | West Virginia | 54045 | 285 | 10 |
430885 | 430885 | 2020-08-13 | Logan | West Virginia | 54045 | 276 | 7 |
427657 | 427657 | 2020-08-12 | Logan | West Virginia | 54045 | 264 | 7 |
424433 | 424433 | 2020-08-11 | Logan | West Virginia | 54045 | 246 | 5 |
421212 | 421212 | 2020-08-10 | Logan | West Virginia | 54045 | 234 | 4 |
417991 | 417991 | 2020-08-09 | Logan | West Virginia | 54045 | 228 | 3 |
414770 | 414770 | 2020-08-08 | Logan | West Virginia | 54045 | 221 | 3 |
411550 | 411550 | 2020-08-07 | Logan | West Virginia | 54045 | 209 | 3 |
408331 | 408331 | 2020-08-06 | Logan | West Virginia | 54045 | 176 | 3 |
405111 | 405111 | 2020-08-05 | Logan | West Virginia | 54045 | 162 | 3 |
401893 | 401893 | 2020-08-04 | Logan | West Virginia | 54045 | 157 | 3 |
398677 | 398677 | 2020-08-03 | Logan | West Virginia | 54045 | 154 | 3 |
395461 | 395461 | 2020-08-02 | Logan | West Virginia | 54045 | 148 | 3 |
392245 | 392245 | 2020-08-01 | Logan | West Virginia | 54045 | 137 | 3 |
389028 | 389028 | 2020-07-31 | Logan | West Virginia | 54045 | 133 | 3 |
385811 | 385811 | 2020-07-30 | Logan | West Virginia | 54045 | 112 | 3 |
382593 | 382593 | 2020-07-29 | Logan | West Virginia | 54045 | 106 | 1 |
379376 | 379376 | 2020-07-28 | Logan | West Virginia | 54045 | 98 | 1 |
376160 | 376160 | 2020-07-27 | Logan | West Virginia | 54045 | 92 | 1 |
372946 | 372946 | 2020-07-26 | Logan | West Virginia | 54045 | 89 | 1 |
369734 | 369734 | 2020-07-25 | Logan | West Virginia | 54045 | 76 | 1 |
366524 | 366524 | 2020-07-24 | Logan | West Virginia | 54045 | 66 | 1 |
363317 | 363317 | 2020-07-23 | Logan | West Virginia | 54045 | 63 | 1 |
360111 | 360111 | 2020-07-22 | Logan | West Virginia | 54045 | 53 | 1 |
356906 | 356906 | 2020-07-21 | Logan | West Virginia | 54045 | 49 | 1 |
353703 | 353703 | 2020-07-20 | Logan | West Virginia | 54045 | 47 | 1 |
350501 | 350501 | 2020-07-19 | Logan | West Virginia | 54045 | 45 | 1 |
347300 | 347300 | 2020-07-18 | Logan | West Virginia | 54045 | 43 | 1 |
344100 | 344100 | 2020-07-17 | Logan | West Virginia | 54045 | 42 | 1 |
340901 | 340901 | 2020-07-16 | Logan | West Virginia | 54045 | 40 | 1 |
337705 | 337705 | 2020-07-15 | Logan | West Virginia | 54045 | 41 | 1 |
334510 | 334510 | 2020-07-14 | Logan | West Virginia | 54045 | 39 | 1 |
331317 | 331317 | 2020-07-13 | Logan | West Virginia | 54045 | 39 | 1 |
328131 | 328131 | 2020-07-12 | Logan | West Virginia | 54045 | 40 | 1 |
324945 | 324945 | 2020-07-11 | Logan | West Virginia | 54045 | 36 | 1 |
321764 | 321764 | 2020-07-10 | Logan | West Virginia | 54045 | 35 | 1 |
318585 | 318585 | 2020-07-09 | Logan | West Virginia | 54045 | 31 | 1 |
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);